Joined: 29 Sep 2005
|Posted: Sun Nov 30, 2008 3:16 am Post subject: Create auto-value field in table by wizard- SOLVED
|I was trying to create a simple little table with a auto-value field, using the table wizard.
(This in ooBase ver 3.0.0, on Win XP) A "little detail" took me a little while to deal with, I thought I'd write things up to save the next person. So: This isn't a question; it's a "How to".
Specifically, I wanted the table's first field to be an auto incrementing integer, to be used as the table's primary key.
In Step 1 select whatever fields you want. You can always rename/ re-type any in the next step
In step 2, I renamed the first field "PriKey", set the field type to "Integer", selected auto-value "yes"....
*** AND TYPED IN "IDENTITY" (it can be in caps or lower case, but you can't use some other string) AS THE "AUTO_INCREMENT STATEMENT ***
(That last sentence in caps, 'cause it is the "hard" part of all of this.)
In step 3: Selected "Use existing field as primary key", and chose "PriKey". Left "Auto Value" ticked.
(A beginners intro to Primary Keys should be up at....
.... and a guide to creating an autoincremented field is at
by 1 December 2008)