Thank you everyone for all the help. I managed to get it working (almost) using a little of each suggestion:
-I really like the idea of controling the case at entry -Reload didn't fix my problem but it showed me that it was a pointer error -which I probably could have fixed but I don't have a copy of R:Scope for v. 7.6 (only 4.5+ which won't help!) -Karen: I ended up following a very similar path to yours, but using a separate table to work in -I've now backed up my Database to another location several times while I worked, and made copies of the table! Now stuck on the last part. Now that I have the FirstNames in a new table, I need to add the last name to the same table, in a different column. My syntax is really, really wrong and I'm not sure how to fix it. (It might be clearer in the morning!) Here is one variation that I have tried (which does not work, of course) but at least it shows what I am trying to do, which is load a column in one table from a column in another table if they have the same Reference Number. UPDATE CompContact SET LName = (SELECT (LName1 FROM TempContacts WHERE LName1 IS NOT NULL ORDER BY Ref#)) Can someone point me in the right direction? thanks again, and have a good Sunday, Lin On Sun, 13 Jan 2008 19:13:06 -0000, "Alastair Burr" <[EMAIL PROTECTED]> said: > 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 > > > > > >
