Thanks Bruce. My Christmas present is if I can get this task scheduling form to work properly. 😊
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of Bruce Chitiea Sent: Thursday, December 24, 2020 10:34 AM To: [email protected] Subject: Re[2]: [RBASE-L] - autonum when creating When there is already data in the table: If you have a temp-table column containing DISTINCT primary key values, you can AUTONUM that column (to add more rows) by following Tony's syntax, but with the NONUM parameter. NONUM autonumbers a column without overwriting existing column values. Merry Christmas, James! Bruce A. Chitiea SafeSectors, Inc. ----------------------------------- 112 Harvard Ave #272 Claremont CA 91711-4716 ----------------------------------- [email protected]<mailto:[email protected]> ----------------------------------- +011 (909) 238-9012 c +011 (909) 912-8678 f ------ Original Message ------ From: "jan johansen" <[email protected]<mailto:[email protected]>> To: "'Jim Belisle' via RBASE-L" <[email protected]<mailto:[email protected]>> Sent: 12/24/2020 6:02:37 AM 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/WC20201224140237.72000E%40jjcalibrations.com<https://groups.google.com/d/msgid/rbase-l/WC20201224140237.72000E%40jjcalibrations.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/CY4PR0201MB339428550691D9CD109F38B4A0DD0%40CY4PR0201MB3394.namprd02.prod.outlook.com.
