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
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