Cool idea. Thanks!
-----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 23 Jan 2012 15:23:07 -0500 Subject: [RBASE-L] - Re: columns At 02:50 PM 1/23/2012, jan johansen wrote: >It's been a while. > >I need to update a number of columns in several tables from REAL to DOUBLE. >Of course I would like this to go as smooth as possible so I hope several >forms and reports don't blow up. >And these columns share the same names across tables. > >Any suggestions before I write my change file? Jan, Here's how: Using R:BASE eXtreme 9.1/9.5 - 64 (of course!) ... 01. CONNECT dbname SET NULL -0- -- check to make sure that IDQUOTES settings are not set to blank -- SHOW CHAR at the R> prompt will reveal the database character settings -- SET IDQUOTES=` if set to blank 02. OUTPUT dbname.str UNLOAD STRUCTURE OUTPUT SCREEN 03. OUTPUT dbname.dat UNLOAD DATA OUTPUT SCREEN 04. DISCONNECT 05. RENAME dbname.rx? dbname_backup.rx? 06. RBEDIT dbname.str to manually edit the database structure file SEARCH and REPLACE all REAL instances to DOUBLE Shift F7 Text to Find: REAL Replace With: DOUBLE [x] Prompt on Replace (x) Scope - Global (x) Origin - Entire Scope Click on [Replace All] button to continue Carefully watch and replace every instance accordingly. Save the file. 07. RUN dbname.str or TRACE dbname.str This will create a fresh database schema with every column converted from REAL to DOUBLE. 08. SET FEEDBACK ON RUN dbname.dat Watch the data being loaded ... SET FEEDBACK OFF 09. All Form "DB Edit" and Report "DB Label" controls should represent the data type accordingly. That's all there is to it! Very Best R:egards, Razzak. www.rbase.com www.Razzak.com www.RazzakMemon.com
