Update a single table in mutiple databases

[adamk84]

Hi,

I am needing to update my _user table accross mutiple of db's. I have tried disconnecting from all the db's and then connecting individual db's but that seems to only update the first db that was connected. So for example, if I have the following databases:
1: System
2: Locations
3: Customers

And I am trying to update the _user table across those three db's, using the disconnect, connect method but, it seems to only update the system db, and refuses to update the second and third db's. Is there a way you can use a find statement / for statement and have it specify which database it should be using? I know in some other rdbms you can use something similar to schema areas to isolate which db runs which command.

Any suggestions would be great.

Thanks
Adam

 

[MaximMonin]

use db alias name to identify DB.
create system._users.
system._users._usrName = ....
create locations._users.

 

[tamhas]

Most likely problem is that you cannot connect to a database and use the database in the same procedure. Do the connect in the top level procedure and then run a subprocedure to do the update.