[Progress Communities] [Progress OpenEdge ABL] Forum Post: Same Table Names Across 2 Databases Needing Simultaneous Connection

Status
Not open for further replies.
V

v205

Guest
Hello: 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 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! v

Continue reading...
 
Status
Not open for further replies.
Top