Lin,
UNLOAD DATA FOR tablename should not export your computed column's data, but it will export the actual columns, of course. When that data is now loaded into another table, the computed columns in the new table will operate on the new data. Therefore you must have a difference in the definition between the two tables to cause the differing results. To see this, try the following: UNLOAD DATA FOR tablename WHERE LIMIT = 1 Now examine the exported data and you'll see that the computed column is not included in the unloaded data. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 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
