Before you start over try to reload the database to a new db name:
CONNECT DB_Name
SET ERR MESS ON
SET MESS ON
RELOAD NewName
If you can get the reload to run you may see all sorts of error messages but
don't panic. If you're lucky you may find that the new database has only
lost the new table or, if you're luckier still, only a few rows from that
table.
I'm assuming you're in single user mode for your work so if you have lost
anything it's only your work and you (probably) know what you did that needs
to be put back.
If you get a reasonably good new database then I would suggest that you move
the old one somewhere safe in another directory so that you can go back to
it if you find more problems in the new one than at first looked likely.
Then reload the new database to the original db name so that then become
your "current" database. You then use the one that you first reloaded to for
your testing to get the names sorted out. When that's done you can
export/import the new data to the "current" database - just ask if you're
not sure how.
Regards,
Alastair.
----- Original Message -----
From: "Claudine Robbins" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Sunday, January 13, 2008 6:02 PM
Subject: [RBASE-L] - Re: pulling a text column apart
SET ERR MESS ON
SET MESS ON
DISC
AUTOCHK nameofdatabase FULL
See what errors exist.
I'm no expert but in your place I would start over (backup the table and
data) and try the update on one row (where limit = 1) at the R> prompt and
see what error it creates.
Or, if you're game, use R:Scope and see if the autofix will solve your
problem on the existing sick table...
Claudine :)
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin
MacDonald
Sent: Sunday, January 13, 2008 11:52 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: pulling a text column apart
Well, now what have I done????
Before getting all these responses, I had managed to fudge my way
through it and I had it all in a Temporary Table. Because I still had
things to do to the data, I decided I should make my Temp table a real
one, in case of a crash (we had a power failure here last night)
After making it a real table, I tried to use an Update command to make
some changes and that's when all went weird. I get an Error Message
Box: "Error in Function RBListofTables". This goes into a loop and I
need to shut down RBase in order to get it to stop. Now, the same thing
happens if I try to open that table, export the data, etc, etc. What
did I do and is there any way to fix it, or do I start over?
Lin
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.2/1221 - Release Date:
12/01/2008 14:04
