Hi,
Horodyski Marek (PZUZ) wrote:
Hi database community.
dbCreate in this code :
dbUseArea( .t., 'DBFCDX', 'POSREDNK.dbf', 'POSREDNIK', .f., .f.)
? 'Połączenie ', RDDINFO( 1001, { "ODBC", "DSN=WPIS;SERVER=KAN;PWD=pass;UID=MyAcc"
}, 'SQLMIX' ) // > 1
? dbCreate( 'POSREDNK', Posrednik->( dbStruct()), 'SQLMIX') // .t.
Returned .t., but table is not created. Connection is correct (selects from
Oracle are going, it is my schema).
How we can created new table in RDBMS ?
1) Table is created but it is released because you did not leave the
workarea open in dbcreate() call. See contrib\rddsql\tests\arrayrdd.prg
for a sample how dbcrerate() works in RDDSQL.
2) RDDSQL does NOT generates hidden queries thus giving all power of SQL
to the hands of programmers. If you want to execute query "CREATE TABLE
posrednk (...", just do:
RDDINFO(RDDI_EXECUTE, "CREATE TABLE posrednk (...")
Regards,
Mindaugas
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
