Ah - so the problem is that, either in another table or in a view, you have this same column, F_SDUE, that is NOT set up as a computed column. To see if it is in a table, do this:
At the R> Prompt, type: LIST COLUMN F_SDUE This will show you all the tables this column is in, AND it will show if it is defined with the proper expression in all tables. Find the table(s) where it is listed without the expression and either drop the column from just those table(s) or rename the column in those table(s). If it doesn't appear to be a problem in a table, then the problem could be in a view where you have included the F_SDUE column but have not also included the required columns in the table that are used in the expression on this column. Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles L. Dore Sent: Tuesday, July 29, 2008 8:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export Here is the error message and the code I used. This column is also in another table. -ERROR- Column F_SDUE exists as both a computed and non-computed column. ( 195) You must rename the non-computed column before you can do an UNLOAD. Unload data for reg_exem using reg# comments as ascii. Thanks for your help -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Tuesday, July 29, 2008 8:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5 export 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.
