Lin When you unload the data specify the columns to unload (exclude the computer columns).
OUT filename.ASC UNLOAD DATA FOR TABLE USI AllColumnsExcludingComputed AS ASCII OUT TERM Now LOAD newTable FROM filename.ASC USI AllColumnExcludingComputed What I do is just copy the using clause from the unload and paste it for the load. Make sure NULL is set to -0- If the tables are identical then you could also just unload all for the table to a file. Edit the file and make sure to remove all rows before the line "LOAD". Connect to new database and drop the table. Make sure NULL is set to -0-. Now just RUN the file you unloaded to. Hope this helps Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Sunday, February 10, 2008 6:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Unload - Load with Computed columns? I need to unload the data from a table in one database and reload it into the same table in another database. The tables contain computed columns. How do I do this? Each time I Load, it adds (and computes) another column, throwing my data off. I tried to export as CSV and then delete the computed column but that causes errors, too. There has to be a simple fix for this, right? thanks, Lin
