Mike,
As Tony suggested, what I would do is unload the structure to file and then search for BP1, it should show you the locations where it is defined. Once you find it, you can make the necessary changes to the structure and data. Computed column data is not downloaded, so it should not be an issue, on the other hand if the column is indeed defined as non-computed, you will need to fix the data. The easiest way would be to delete the data section from your UNLOAD ALL file for that table and unload that file individually, selecting only the columns you need and then letting the database compute the values, once the structure has been corrected. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Mike Sent: Tuesday, March 12, 2013 9:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Problems with unload ALL Would R:Scope help? Sent from my iPhone On Mar 12, 2013, at 9:07 AM, Karen Tellef <[email protected]> wrote: I've seen this from time to time. The only way I've fixed it is by dropping the column from all tables, then redefining it Karen -----Original Message----- From: Michael J. Sinclair <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Mar 11, 2013 10:49 pm Subject: [RBASE-L] - Problems with unload ALL Hi, I am trying to clean up my database (Rbase 9.5 32) When I try to run this command... UNLOAD ALL I get this error message... -ERROR- Column BP1 exists as both a computed and non-computed column. (195) But when I try to find it by doing this... LIST column BP1 I get this.... Column Name Table Name Attributes ------------------ ------------------ --------------------------------------- BP1 VITALS0 Type : TEXT 12 Compute: ((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1))) vitals1 Type : TEXT 12 Compute: ((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1))) So how do I find the non-computed column?? Mike
