Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

AutoNumber Field

Quote Reply
AutoNumber Field
Hi,

Anyone can help me how to create an AutoNumber field with LinkSQL ?

thanks
Quote Reply
Re: AutoNumber Field In reply to
You edit the database and set the extra attributes to "AutoIncrement" in the field definition.

Because a table can only have one auto incrememt field, and it MUST be indexed, I don't think you can do it through the Admin screen, but you can isue "alter" statements through the SQL Monitor.