ADORDD for now is unstable because evolution of ole have created involution in adodd I invite everybody with a problem using adordd post problem at http://forums.fivetechsupport.com/viewtopic.php?f=3&t=6814&start=165
I suggest document structure of POSREDNK.dbf using array instead of Posrednik->( dbStruct()) use .... {{"name","c",20,0} } 2009/10/16 Horodyski Marek (PZUZ) <m.horody...@pzuzycie.com.pl>: >>-----Original Message----- >>From: Horodyski Marek (PZUZ) >>Sent: Friday, October 16, 2009 12:43 PM >>To: Harbour Project Main Developer List. >>Subject: [Harbour] SqlMix and dbcreated >> >>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 ? > > > When I try make this via ADORDD, have error : > > .[WIN_OLEAUTO:CLOSE(0)] > > (b)ERRORSYS(259) > WIN_OLEAUTO:CLOSE(0) > ADO_CREATE(0) > DBCREATE(0) > (b)KOMPILATOR(0) > BOSS(0) > (b)KOMPILATOR(0) > BOSS(0) > KODKLAW(0) > OPCJA(0) > (b)KOMPILATOR(0) > BOSS(0) > MAIN(244) > oErr:severity_____ 2 > oErr:osCode_______ 0 > oErr:subsystem()__BASE > oErr:subCode______ 3012 > oErr:description__Nieprawidłowy argument > oErr:filename_____ > oErr:operation____CLOSE > oErr:genCode______ 1 > oErr:args_________U > > And table is too not created. > We don't can use DDL expressions on RDBMS. > > Regards, > Marek Horodyski > _______________________________________________ > Harbour mailing list > Harbour@harbour-project.org > http://lists.harbour-project.org/mailman/listinfo/harbour > -- Massimo Belgrano _______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour