You'll also have to add back any auotnumbering, comments and rules.
Here's another way to do this, and be able to easily retain all the other
pieces to the puzzle.
OUTPUT tablename.str
UNLOAD STRUCTURE FROM tablename
OUTPUT SCREEN
Follow Razzak's steps:
PROJECT TEMPORARY TableNameA FROM ActualTable USING +
ColumnList
DROP ActualTable
PROJECT ActualTable FROM TableNameA USING ALL
DROP TableNameA
RBEDIT tablename.str and remove the top section containing the CREATE TABLE
statement.
Leave the rest of the file as is - all the CREATE INDEX, AUTONUM, RULES,
COMMENT
and so on. RUN this file to re-generate all those processes on the revised
table layout.
But, yeah, it sure would be easier to just be able to move the column where
you wanted it!
Sami
-----------------------------------------------------------
Sami Aaron
Software Management Specialists
13214 W. 62nd Terr, #139
Shawnee KS 66216
913-915-1971
http://www.softwaremgmt.com
----- Original Message -----
From: Vic Cook
To: [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 8:58 AM
Subject: Re: MOVING COLUMNS IN 6.5+ FOR WINDOWS - Razzak's Reply
And after a double PROJECT, you'll probably have to rebuild your
indices/indexes.
-- Vic
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of A. Razzak Memon
Sent: Tuesday, August 21, 2001 4:39 PM
To: [EMAIL PROTECTED]
Subject: Re: MOVING COLUMNS IN 6.5+ FOR WINDOWS - Razzak's Reply
Dan,
03. At the mighty R> prompt:
PROJECT TEMPORARY TableNameA FROM ActualTable USING +
ColumnList
Using ColumnList is the KEY here ... Arrange it
anyway you wish ...
04. DROP ActualTable
05. PROJECT ActualTable FROM TableNameA USING ALL
06. Either DROP TableNameA or DISConnect to drop any
TEMPORARY Table(s). There you have it Your Way!
Have Fun!
Very Best Regards,
Razzak.
At 03:25 PM 8/21/2001 -0700, Dan Goldberg wrote:
>>>> Does anybody know an easy way to move columns
when designing a table?? In the dos version you could move columns and it
would not lose any data.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
