Unload data for reg_exem using reg# comments as ascii.
IF that's two columns - "reg#" and "comments" - then don't you need a comma
between them?
Regards,
Alastair.
----- Original Message -----
From: "Charles L. Dore" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 29, 2008 2:13 PM
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.
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.6/1579 - Release Date: 29/07/2008
06:43
