[RBASE-L] - RE: PROJECT was (Re: ALTER TABLE: Column ordering)

[Bruce Chitiea]

Claudine:

Wow, thanks. I needed that very trick Thursday, AaMOF (As a Matter Of Fact, so many good acronyms on this list).

And to you; here's hoping America rediscovers what the 4th's all about.

Bruce

-------- Original Message --------
Subject: [RBASE-L] - RE: PROJECT was (Re: ALTER TABLE: Column ordering)
From: "Claudine Robbins" <claudinerobb...@earthlink.net>
Date: Sat, June 30, 2012 7:17 am
To: rbase-l@rbase.com (RBASE-L Mailing List)

Bruce,

 

I just discovered another trick to do with PROJECT.

 

Sometimes I need two copies of a single table to be used in a view.  Since the Views|New|Query Wizard only allows one instance each of tables, I PROJECT a temporary subset of the permanent table and use the Query Wizard to build my view letting it correctly write the SQL command relationships I need.  Then, in the view definition, I substitute the real table name for the temp subset.  I just had an instance of using three tables twice and it made defining a single view much easier!

 

Claudine

 

P.S.: Have a wonderful 4^th of July!

 

---

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Bruce Chitiea
Sent: Friday, June 29, 2012 1:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: ALTER TABLE: Column ordering

 

Razzak:

 

Very handy, PROJECT. Been learning just how handy, of late; but I hadn't thought of that.

 

Thanks!

 

Bruce

-------- Original Message --------
Subject: [RBASE-L] - Re: ALTER TABLE: Column ordering
From: "A. Razzak Memon" <raz...@rbase.com>
Date: Fri, June 29, 2012 10:46 am
To: rbase-l@rbase.com (RBASE-L Mailing List)

At 01:33 PM 6/29/2012, Bruce Chitiea wrote:

>I can't see where the ALTER TABLE <tblname> ADD COLUMN ... syntax
>allows positioning of
>the created column within its table. So I go to the Data Designer for that.
>
>Is there any such command line feature?


Bruce,

FWIW, the positioning of table columns is an eXclusive feature of
R:BASE Data Designer.

However, you may use the PROJECT command to define a temporary table
with all columns
in the order as you wish, and then DROP the actual table (if not
constraint by PK/FK
relationship), and finally PROJECT the temporary table to the actual
table name.

HELP PROJECT will illustrate it all!

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.