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]
-----------------------------------
+011 (909) 238-9012 c
+011 (909) 912-8678 f
------ Original Message ------
From: "jan johansen" <[email protected]>
To: "'Jim Belisle' via RBASE-L" <[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]>
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
<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
<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
<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/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/emf4e39e3d-ed72-47ad-a02e-c16e60153999%40pathfinder.
