As a
suggestion for version 7 to put it in the designer to move columns like in
moving columns in forms....
hint
hint
-----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,
Using The Glorious R:BASE 2000 (ver 6.5++), you can always
use the powerful PROJECT TEMPORARY TableName command to
achieve the same object.
Here's how ...
Steps:
01. ALWAYS make a backup copy of your database.
02. Launch TGRB2000 for Windows
03. SET MULTI OFF (if on the network)
04. CONNect DBName
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.
==================================-=============================
