Jenna -
You just add the AUTONUM command right after the CREATE TABLE command.
To see how it would work, find an existing table you have with an autonumber
field, and:
OUTPUT tablename.str
UNLOAD STRUCTURE FOR tablename
OUTPUT SCREEN
When you look at the file, tablename.str, you will see the AUTONUM command
near the bottom of the file.
-----------------------------------------------------------
Sami Aaron
Software Management Specialists
13214 W. 62nd Terr, #139
Shawnee KS 66216
913-915-1971
http://www.softwaremgmt.com
----- Original Message -----
From: "Jenna Klein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 20, 2001 7:31 AM
Subject: Undocumented Autonum Feature? (I hope)
> While the autonum command is simple enough, is there a way, perhaps
> undocumented, to create the autonumbering as part of a create table
> command? I know other SQL variants allow this (I'm thinking of MySQL in
> particular)
>
> Something like: CREATE TABLE WithID (MyTableID INT NOT NULL PRIMARY KEY
> AUTONUM(1,1))
>
> If there isn't already such a feature, would it be trouble to add it?
>
> Thanks!
>
> Jenna
>
>
>
