User Tools

Site Tools


preautoinc.htm
Navigation:  SQL Driver Strings(General) >====== PREAUTOINC ====== Previous pageReturn to chapter overviewNext page

DRIVER('SQLDriver', '/PREAUTOINC = [TRUE/FALSE] ' )

[ Buffer“ = ] SEND(file, 'PREAUTOINC [ = TRUE/FALSE ]' )

blk2blue.jpg

The /PREAUTOINC driver string is used to inform the target table as to when a server side auto-incrementing field is incremented in regards to the SQL SELECT statement when an Insert action is active. When the string is set to TRUE, (except Oracle), the SQL code is issued after the SELECT,. For Oracle, it is issued before the SELECT (when set to TRUE). TRUE is the driver's strings default setting (e.g., if it omitted, it is implicitly TRUE).

The Dictionary Editor contains a Driver String Options dialog in the Table Properties to allow easy entry of this string.

See Also:     Server side auto-incrementing values

preautoinc.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1