Mike,
On the whole database or just a table?
If just a table I suspect that you are including the computed column in your
list of columns to unload.
As long as you include both the component columns and define the computed in
whatever table you are going to LOAD back into you should be alright as the
computed column will be filled by R:Base.
Regards,
Alastair.
From: Michael J. Sinclair
Sent: Monday, December 17, 2012 7:00 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - UNLOAD error
Hi All,
When I try to do an UNLOAD on my database, I get this...
-ERROR- Column BP1 exists as both a computed and non-computed column. ( 195)
You must rename the non-computed column before you can do an UNLOAD.
When I try to find which table(s) have the offending column(s) I get this....
R>list column BP1
Column Name Table Name Attributes
------------------ ------------------ ---------------------------------------
BP1 VITALS0 Type : TEXT 12
Compute:
((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1)))
VITALS1 Type : TEXT 12
Compute:
((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1)))
Looking at the above, I see 2 identical definitions for the column called BP1.
Why is the UNLOAD failing?
Mike
