At 06:47 PM 4/20/2010, Matthew Burke wrote:
I think most of you can see what I am *trying* to do just by looking at the
original command I was unsuccessful with. So here it is.
UPDATE Table1 SET T1.* = T2.* FROM Table1 T1, Table2 T2 WHERE T1.ID = T2.ID
Can I keep an UPDATE command this simple by
simply changing a few items around?
Im trying to avoid
UPDATE Table1 SET T1.Col1 = T2.Col1, T1.Col2 = T2.Col2
multiplied by 300, if it is at all possible.
Matthew,
R:BASE Replication (synchronizing two R:BASE tables) within the same database
or different database is made possible by R:BASE Synchronizer (R:Synchronizer).
For complete details: http://www.RSynchronizer.com
For more R:BASE Solutions: http://www.RBASESolutions.com
Very Best R:egards,
Razzak.
--- RBASE-L
=======================3D=======================3
D=
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)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
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.
=======================3D=======================3
D=
