Good morning Xbase group
I am testing ADS, so far I am amazed at its
performance!.
The test is adding 2 records to a table and I am not
understanding the syntax for use
this is my code
AdsCreateSQLStatement( nHandle, @nStat )
AdsStmtSetTableType( nStat, ADS_CDX
)
AdsStmtSetTableLockType( nStat,ADS_COMPATIBLE_LOCKING
)
c1 := “INSERT INTO remito4tango “ +;
“(PROVEE,TIPCOM,PVENTA,NROCOM,FECHA_,ESTADO,RESUME,CONTR_) “
+;
“VALUES “ +;
“(‘05918',-5,1,338,'2005-01-21','1','05918 1
1 355 ',' ') ,” +; <- error position, Location 91
“(‘05919',-5,1,339,'2005-01-21','1','05918 1
1 355 ',' ');”
AdsExecuteSQLDirect( nStat, c1, @nCursor )
b1 := 0
b2 := Space( 1000 )
b3 := 1000
AdsGetLastError( @b1, @b2, @b3 )
the error is
b1 = 7200
b2 = Error 7200: AQE
Error: State = 42000; NativeError = 2115;
[iAnywhere Solutions][Advantage SQL Engine]Expected lexical element
not found: ( You are missing the opening "(" after the keyword
VALUES in INSERT INTO. -- Location of error in the SQL statement
is: 91
b3 = 265
the error points to the comma between the definition
of both records given by the parentheses
I start with this syntax because both mysql and
ms-sql work! I hoped that in ads too ... could you tell me how I
should build the SQL string to be able to insert 2 records in a
single sentence?
greetings to all