Databases at different locations?

[SSSMan]

I have a program that is used at multiple locations. At each location, there is a database called JMS. The program has been designed to access the database at each of the different locations or backup directories to check information such as inventory quantities. There is also one part that is designed to make an update to one of the other locations that is not the current location. When this process is run, the tableupdate and the RI_Update is going to the wrong database and base table from the view.

I make sure that I selected the correct database before I do the tableupdate.

All the databases at all the locations are named the same.

Is there any way to make sure that the correct database is getting updated?

Thanks, David

 

[DSummZZZ]

Are you sure you're referencing the correct table(s) with your view?
Can you use the tables directly with an alias or must you use a view?
If you can use the tables directly, you should be able to update them by issuing an INSERT INTO:

USE remote1\jms ALIAS rjms1
USE remote2\jms ALIAS rjms2
.
.
.
IF whatever
   INSERT INTO rjms1 FROM ....
ENDIF

-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm