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 4th of July! _____ From: [email protected] [mailto:[email protected]] 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" <[email protected]> Date: Fri, June 29, 2012 10:46 am To: [email protected] (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.
