If you don't want to do that, you can do it the old-fashioned way thru code:

ALTER table1 ALTER RealCol TO tmpDoubleCol Double
ALTER table2 ALTER RealCol TO tmpDoubleCol Double
ALTER BiggestTable ALTER RealCol TO RealCol Double
RENAME COL tmpDoubleCol TO RealCol

Karen


 

 

 

-----Original Message-----
From: jan johansen <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Fri, Aug 8, 2014 10:15 am
Subject: [RBASE-L] - multi column change



        Ok.
         
        I need to change a number of columns with the same name from REAL to 
DOUBLE.
         
        I know that I have done this before.
        If I remember correctly you unload the structure and data separately,
        search for and modify the structure file for the new data types,
        run the structure file, run the data file, and then check your work.
         
        Does that sound about right? 
         
        Jan
         
         
         

Reply via email to