Datawindows with 2 datasources

[SvenKnie]

Hello,

I have following problem. In an Application there are several datawindows with 2 or more tabels as datasources. All works fine, but now I have to split the database into 2 databases.

Now the problem is in one datawindow 2 tables uses the first database and 2 other tables should use the second database.

Is there any chance to do this ?

I have to work with Powerbuilder 7.03

thanks
Sven

 

[jehierteam]

Hello,

You have to create 2 transactions. In the constructor section of the datawindow1 you have to specify the transaction like this :
NameofDatawindow1.settransobject(Name of the transaction1)
In the datawindow2 you have to specify the transaction like this :
NameofDatawindow2.settransobject(Name of the transaction2)

You will not use SQLCA transaction.

 

[SvenKnie]

Hello,

thank you for your reply.
To connect to 2 Database isn't the problem (only to 3 Databases doesn't work).

The problem is, I have 1 Datawindow which gets data from several tables. Since now all datas come from one Database, but now some tables should stored in Database "A" and the other tables in Database "B".

And my problem is, this will happen with many datawindows.

 

[mbalent]

I would create a view in the database which has all the data from whatever the various sources are. This way you can access them easily (just like a table in a single db).

Matt

"Nature forges everything on the anvil of time