Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Fri, Aug 31 2007 3:12 PM	Permanent Link
randyt	I need to add an identity column to a table and have it autopopulate itself, this could be done in ver 3 just by adding an autoinc column. how does this get done with ElevateDb. thanks Randy
Fri, Aug 31 2007 7:08 PM	Permanent Link
Michael Thompson	Create an Integer column and check the generate checkbox. This is the autoinc. In code it looks like this: "id" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1), randyt <randyt@xmission.com> wrote: I need to add an identity column to a table and have it autopopulate itself, this could be done in ver 3 just by adding an autoinc column. how does this get done with ElevateDb. thanks Randy
Sat, Sep 1 2007 8:43 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Randy, << I need to add an identity column to a table and have it autopopulate itself, this could be done in ver 3 just by adding an autoinc column. how does this get done with ElevateDb. >> Michael is correct - identity columns work, by default, just like autoinc columns in DBISAM. -- Tim Young Elevate Software www.elevatesoft.com