Subject TIB_dSQL Success Test
Author John W. (Jack) Cane
Post date 2013-09-20T04:02:43Z
Please advise the best, the correct test to confirm success of an insert query using variable dSql of type tiB_dSQL.

Inherited, legacy code contains a test for the value of dSql.Fields[0].AsInteger. That fails with an access violation.

If that is the best test, would you please give me the required statement to prepare that query. I tried appending the clause, 'Returning ' + pkFieldName, but the error remains.

Would prefer to make the code general, with the given condition that Fields[0] is always the primary key field of my tables.

Best,
jwc
from iMac