Jim,
Yes. The AUTONUM is issued after the table is created and before you insert data. Jan From: "'Jim Belisle' via RBASE-L" <[email protected]> To: "[email protected]" <[email protected]> Date: Thu, 24 Dec 2020 13:51:03 +0000 Subject: RE: [RBASE-L] - autonum when creating Tony, So after you create the table but before adding rows you use the code you mentioned instead of the alter table command? I saw the syntax you mentioned but was not sure if I used the alter command. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] <[email protected]> On Behalf Of Tony IJntema Sent: Thursday, December 24, 2020 7:41 AM To: [email protected] Subject: Re: [RBASE-L] - autonum when creating CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. AUTONUM <Columnname> IN <tablename> USING <Startnummber> <increase> NUM Tony Op 24-12-2020 om 14:27 schreef 'Jim Belisle' via RBASE-L: What is the proper syntax for creating a column within a temp table as an auto numbered column? James Belisle Making Information Systems People Friendly Since 1990 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F36E4750A622B0545B5FA0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339466EAC7B6E384E173574DA0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20201224140237.72000E%40jjcalibrations.com.

