Subject Re: [IBO] TIB_dSQL Success Test
Author John W. (Jack) Cane
Post date 2013-09-20T13:37:17Z
Is it possible to retrieve the primary key value of a single row inserted?

Best,
jwc
from iMac

On Sep 20, 2013, at 12:30 AM, IBO Support List <supportlist@...> wrote:

 

You can check the RowsAffected property.
 
Jason
 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of John W. (Jack) Cane
Sent: Thursday, September 19, 2013 10:03 PM
To: IBObjects Support
Subject: [IBO] TIB_dSQL Success Test

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