Home > database >  How to realize the select statement in the PB database interaction window query multiple data source
How to realize the select statement in the PB database interaction window query multiple data source

Time:09-26

Consult everybody:

Under PB database connection window, how to implement in a SELECT statement query two data sources of data at the same time, for example:

Oracle8 database tables and data Access and foxpro table, ask everybody to help,

CodePudding user response:

If not possible, because SetTransOBject () function is only one parameter, only support a things, let's build a temporary table, if are different libraries can use oracle DataBase links.

CodePudding user response:

reference 1st floor hyf_0023 response:
if not possible, because SetTransOBject () function is only one parameter, only support a things, let's build a temporary table, if are different libraries can use oracle DataBase links.

.

CodePudding user response:

It is best to multiple DW controls to implement,
Build multiple transaction
Each of the DW bind a transaction.

CodePudding user response:

Try the link to the server
  • Related