Hmmm... an UNLOAD should allow you to UNLOAD a computed column. Or is the problem that once you UNLOAD a computed column you can't LOAD the data back into a table with the same computed column? If that's the case, use the "USING columnlist" option in the UNLOAD statement and exclude the computed column from the list.
If that doesn't work for you, post your exact set of commands and error messages here. Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles L. Dore Sent: Tuesday, July 29, 2008 6:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export It won't let me do the unload command because of a computed field. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Tuesday, July 29, 2008 7:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export Charles - Exactly how are you trying to do this export? Here's one way: SET WIDTH 5000 OUTPUT filename.dta UNLOAD DATA FOR tablename USING columnlist AS ASCII WHERE clause ORDER BY columnlist OUTPUT SCREEN SET WIDTH 79 Or type HELP UNLOAD at the R> Prompt for more options. Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles L. Dore Sent: Tuesday, July 29, 2008 6:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export Is there a limitation on the field size for exporting? It seems that it will only export 256 characters. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, July 28, 2008 1:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export At 01:37 PM 7/28/2008, Charles L. Dore wrote: >I am trying to export a table with a note field. The export works okay, >but truncates the notes field. Is there another way to export the data? Charles, Take a look at the enhanced R:BASE GATEWAY Import/Export modules in R:BASE 7.6 and Turbo V-8 for Windows. R:BASE 7.6 for Windows (FREE Evaluation Version): http://www.rbase.com/evaluation/ Product Details: http://www.rbase.com/rbg76/ http://www.rbase.com/rbg8/ Product Comparison: http://www.rbase.com/products/compare.php Good luck! Very Best R:egards, Razzak.
