Subject RE: [IBO] Manual insertion of new record
Author IBO Support List
Post date 2014-06-03T15:40:58Z
There likely is something that can be set to allow for this.
Will you send me more detailed information about the table and where in IB_SQL you were doing the insert?
 
Ideally it should make use of the RETURNING clause so that whatever value the server provides comes back to the client.
 
Thanks,
Jason
 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, June 2, 2014 9:03 AM
To: IBObjects ListServer
Subject: [IBO] Manual insertion of new record

Although all of my tables contain triggers to manage primary key field values. today I noticed that, when using ibSQL to insert a new record manually, I was required to type in the PK value. This required navigating away from the insertion point because I'm entering into the new record, the FK value of some current record), finding the current maximum, adding 1 and making a correct entry.

Wondering if there is a setting to allow automatic entry of the new PK value, into ibSQL.

Best,
jwc