I am glad you were able to get some sunshine. Just a little time zone difference😊
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 9:29 AM To: 'Jim Belisle' via RBASE-L <[email protected]> Subject: Re: [RBASE-L] - autonum when creating James, Sorry for not replying. However the sun was shining after days with a lot of rain. So I took my bike and went to the local river (The IJssel in Holland) to get some fresh air. Jan was right with autonum. What I sometimes do with (temp) tables, is create the table with RBdefine and then unload the structure. Then you are sure everything is in the proper order. Tony Op 24-12-2020 om 15:03 schreef 'Jim Belisle' via RBASE-L: 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]<mailto:[email protected]> <[email protected]><mailto:[email protected]> On Behalf Of jan johansen Sent: Thursday, December 24, 2020 8:03 AM To: 'Jim Belisle' via RBASE-L <[email protected]><mailto:[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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB33946BAECEAF0DE8BB73F771A0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB33946BAECEAF0DE8BB73F771A0DD0%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/CY4PR0201MB3394E7E82C70D460AAB96691A0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com.
