F_SDUE was only in one table, it's not even in the table I am trying to
export. It doesn't make any sense to me.
Column Name Table Name Attributes
------------------ ------------------
---------------------------------------
F_SDUE BDINFO01 Type : DATE
Compute: FYE+60
Thanks again
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami
Aaron
Sent: Tuesday, July 29, 2008 9:27 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: 6.5 export
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.
