Yes! Thank you! Lin
On Mon, 14 Jan 2008 08:16:04 -0000, "Alastair Burr" <[EMAIL PROTECTED]> said: > Try this: > > UPDATE CompContact SET LName = T2.LName1 + > FROM CompContact T1, TempContacts T2 + > WHERE T1.IDNUM = T2.IDNUM + > AND T1.LName1 IS NOT NULL > > You need to give the tables an alias to link on (T1 & T2) and a linking > column (IDNUM). UPDATE [table] and SET [column] don't need the alias as > they > are part of the command itself. > > Please double check that I have your table and column names associated > correctly and be sure that you have a backup of the CompContact table > since > you will find it almost impossible to go back once the update is run! > > Regards, > Alastair. > > > ----- Original Message ----- > From: "Lin MacDonald" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Monday, January 14, 2008 12:39 AM > Subject: [RBASE-L] - Re: pulling a text column apart > > > > 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 > >> > > >> > > >> > >> > > > > > > > > > > -- > > 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 > > > > > >
