03-05-2010 08:42 AM
So once again proving my limitations in the SQL universe I have fallen and can't bet back up. I would like to accomplish what I know are 2 easy to issue commands, but darn if I don't know how. (That SQL course is looking better and better all the time...) Anyway, I digress.
Our Business Partner created (I believe) a table called "Account Extension". Under that table, there is a sub table called "Userinfo". (Please see attached image for more "clarity").
What I want to do is -
1) Count how many records exist for UserID=U6UJ9A000018, and once I know and confirm this number,
2) Replace all of the U6UJ9A000018 with UserID=U6UJ9A00002M, and
3) Ensure that the change get's replicated out to the field.
I know what I don't know, and this is one of them. In an older dBase time, not an issue. But I'm showing my age here...
Thanks for any assistance.
Solved! Go to Solution.
03-05-2010 09:30 AM
SELECT COUNT (*) FROM ACCOUNTEXTENSION
UPDATE ACCOUNTEXTENSION SET USERID = 'U6UJ9A00002M' WHERE USERID = 'U6UJ9A000018'
Run the update statement in the ExecuteSQL function in the Administrator application set it to send the command to all remotes.