Thanks Razzak. On it.
Bruce
-------- Original Message --------
Subject: [RBASE-L] - Re: Creating Tables at R>: Sequence of Elements
From: "A. Razzak Memon" <[email protected]>
Date: Fri, July 20, 2012 11:50 am
To: [email protected] (RBASE-L Mailing List)
At 02:33 PM 7/20/2012, Bruce Chitiea wrote:
>I'm experimenting with table creation at the R>Prompt. Wanting to
>bullet-proof
>my approach to coding. An UNLOAD of one existing table shows the sequence:
>
>CREATE TABLE ...
>ALTER TABLE ... ADD PRIMARY KEY ...
>AUTONUM ...
>RULES ...
>RULES ...
>
>To COMMENT ON elements, would I:
>
>a) Append them after RULES, or
>b) Insert them between the existing elements?
Bruce,
The best experiment would be to create a scenario manually, and then use the
bullet-proof option of "Unload Definition with Constraints, Indexes, and
Comments" to see how R:BASE engine creates a file with correct sequence,
using the latest and greatest versions of R:BASE, of course!
Here's how:
01. Start R:BASE eXtreme 9.1/9.5 for Windows
02. CONNECT dbname
03. Database Explorer | Tables ...
04. Highlight/Select the appropriate table | Right Click | Unload ...
Select Definition with Constraints, Indexes, and Comments
Once the file is created, then open that file using R:BASE Editor and
look at the sequence.
COMMENTing all columns and then table should be the very last block.
That's all there is to it.
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
