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 [cid:[email protected]] 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 [cid:[email protected]] -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F36E4750A622B0545B5FA0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F36E4750A622B0545B5FA0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. ________________________________ -- 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.
