Retrieve data from two different database 2

[beti]

Hi all,

I have a question reqarding retrieve data from 2 different database.
Is it possible to retrieve data from 2 different database in a datawindow? If so, how do I handle it?

Thanks!

 

[tang1007]

use a datawindow to retrieve data from two different database?
I thank it's impossible.

 

[PowerObject]

It IS possible to retrieve/update multiple tables from different schemas/databases (including cross-dBMS) using a "single" datawindow! Simply surf to:

http://groups.yahoo.com/group/PowerObject

Retrieve from tables in multiple databases/schemas:

http://groups.yahoo.com/group/PowerObject/message/1892

Update tables in multiple databases/schemas:

http://groups.yahoo.com/group/PowerObject/message/5395

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[beti]

Hi PowerOject,

Sorry I don't get access to the address you mentioned above. Can you please kindly copy the message and display in here. Many thanks!

 

[tabhijit]

Hi beti,

Add return 2 in your retrievestart event.
Retrieve rows from 1st database.
Change transaction object.
Retrieve rows from 2nd database.
Restore first transaction objects.

Make sure that you are not resetting dw.

Your code will look like,

retrieveStart event of dw
Return 2

ue_retrieve event of window

dw_1.SetTransObject (tr1)
dw_1.Retrieve (...)

dw_1.SetTransObject (tr2)
dw_1.Retrieve (...)

dw_1.SetTransObject (tr1)

Cheers,
Abhijit.

 

[PowerObject]

I'm sorry I forgot to inform you. PowerObject! group's message archives are accessible to its members only. You will have access to the URLs once you join the group:

http://groups.yahoo.com/group/PowerObject

http://groups.yahoo.com/group/PowerObject/join

---
PowerObject!