Doug,
I agree and like using temp tables and views.
Most of these temp tables and views are created in one procedure, which
is executed when the application is started.
Advantage: All temp tables / views are concentrated in one procedure
and always available troughout the application.
Disadvantage: If the database is disconnected you have to re-run the
procedure.
I have enjoyed the sunshine. In this time of the year there are a lot of
geese (1000's ) from the North and Russia spending the winter here. They
produce a lot of noise.
Wish you a merry Christmas
Tony
Op 24-12-2020 om 17:46 schreef Doug Hamilton:
Tony, I often use temp tables during processing.
A(nother) quick method to create an empty table is:
PROJECT TEMPORARY Table1 FROM Table2 USING ALL WHERE LIMIT = 0
Or if you only need certain columns, USING collist WHERE LIMIT = 0
If the table structure should change in the future, I don't have to
crawl through all the code looking for the table definitions. The
projected temp table structure will always be current.
Enjoy the sunshine.
Doug
On 12/24/2020 9:28 AM, Tony IJntema wrote:
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*
*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*
*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*
--
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]
<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
<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
<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
<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/a17b57fc-0aa1-c147-dfd4-ee782fd117ad%40cio-bv.nl
<https://groups.google.com/d/msgid/rbase-l/a17b57fc-0aa1-c147-dfd4-ee782fd117ad%40cio-bv.nl?utm_medium=email&utm_source=footer>.
------------------------------------------------------------------------
Avast logo <https://www.avast.com/antivirus>
This email has been checked for viruses by Avast antivirus software.
www.avast.com <https://www.avast.com/antivirus>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/ea112488-0a88-6b56-91e8-69416a55af89%40wi.rr.com
<https://groups.google.com/d/msgid/rbase-l/ea112488-0a88-6b56-91e8-69416a55af89%40wi.rr.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/c281ddc0-2694-1fae-ed20-b01715e87a1b%40cio-bv.nl.
