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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
