|
Hello, I have the following SQL statement: IF ::conn.TransactionCount > 0 THEN ROLLBACK; ENDIF; It works perfect from ARC but using it from a remote computer via Advantage StreamlineSQL ODBC, it throw an error "2141 Parameter missing". Any clues? Thanks, Titus |
|
Looks like the ODBC driver interprets the : as a parameter. You might try using a UDF: create function getTransactionCount() returns integer begin return ::conn.TransactionCount; end;and then change your statement to IF getTransactionCount() > 0 THEN ROLLBACK; ENDIF; Indeed it did the trick. Note: a Data Directory is required. I suppose that this is a bug in ODBC and I am not the single one who reached it. There is any chance to be solved?
(09 Dec '15, 16:15)
Titus
in order to get it solved you need to contact SAP.
(09 Dec '15, 16:49)
Joachim Duerr
What programming language are you using? In Delphi there is an option (called
(09 Dec '15, 18:17)
Jens Mühlenhoff
|
