Thanks to Tony and Jan. I seldom use the auto num so all new to me. James Belisle
Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of jan johansen Sent: Thursday, December 24, 2020 8:03 AM To: 'Jim Belisle' via RBASE-L <[email protected]> Subject: RE: [RBASE-L] - autonum when creating 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]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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 [cid:[email protected]] From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Tony IJntema Sent: Thursday, December 24, 2020 7:41 AM To: [email protected]<mailto:[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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339466EAC7B6E384E173574DA0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339466EAC7B6E384E173574DA0DD0%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/CY4PR0201MB33946BAECEAF0DE8BB73F771A0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com.
