I am trying to figure out how to resolve this scenario, where we have several programs written against an older database called "WDS" that has a table called "Location" and now there is a new database called "Fascor" (this is a SQL Server Data Server) in the mix that we are also using, that also has a table called "Location".
Our older code does not use database name qualifiers for tables. Considering that, how does one compile code like this? Imagine that before compiling the following code, you are connected to both WDS and Fascor databases, and both have the Location table:
// The FOR EACH is referencing a WDS Location table in this example
FOR EACH Location NO-LOCK: <-- this line represents existing code
FIND Fascor.Location WHERE ...<>... <-- this line is new code
END. <-- this line represents existing code
Is there a way to resolve this using some start-up parameters etc.?
Thanks in advance!