| **Navigation:**  SQL Driver Strings(General) >====== PREAUTOINC ====== | [[orderinselect.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[turbosql.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

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

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

{{blk2blue.jpg|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 in clarion 6 3 sql file drivers.htm|Server side auto-incrementing values]]