Relational database in progress procedure

[Mkontwg]

Hi Team

I want to ask if there is a person, can show me in progress using sample procedure, that will service two relational database in one .p file. An example will be appreciated thanks.

 

[jdpjamesp]

So long as the two databases don't share table names Progress is able to discern which database you're using so just go on as you are. If the databases share table names you will need to qualify them with the database name.

for each database1.table1 no-lock:
end. 

for each database2.table1 no-lock:
end.

Other than that you don't need to do anything special.

 

[Mkontwg]

Hi Cringer

Your example above shows...? Relational types to each schema name with its table fields? If so how do i create a procedure that will invoke both tables and shemas on my procedure? In another words i want to understand flow process

 

[ForEachInvoiceDelete]

Do you want to use multiple databases, or a single database with multiple tables linked to each other?

 

[Rob Fitzpatrick]

One of our applications is deployed with anywhere from one to four databases, depending on which options a client buys. Our table names are unique across all databases, so developers don't have to do anything special to reference them, e.g. qualifying table names with DB names.

E.g.:

for each TableInDB1 no-lock:
  find TableInDB2 no-lock where condition...
end.

 

[Mkontwg]

Do you want to use multiple databases, or a single database with multiple tables linked to each other?

I want to use multiple database with one procedure