To connect two databases: A: access database: create your own
B, the oracle database: access only query

A library with the main table DJ_RY, primary key bh
B in the library has the main table DJ_RY, primary key bh, otherwise other table DJ_QX, DJ_ZG table, can be associated with bh

Now in order to achieve the following functions: connection A at the same time, B library database, put A.. DJ_RY with B..
DJ_RY (according to the demandMay be associated with other tables in the library B) with bh correlation shown in a grid format of the data window, then
Perform other update operations, such as
Now the main problems is to display the same data window problem
How to implement this feature, warrior, please advice, thank you!!!!!

CodePudding user response:

Using pb9 version

CodePudding user response:

Window put 3 dw
Dw_1 connection A library, hidden
Dw_2 connection B library, hidden
Dw_3 does not connect any library, not hide, external database source
Data through the loop dw_1, dw_2 setitem on dw_3 displayed

CodePudding user response:

Of data synchronization in the database A needs to the oracle, and then retrieved

CodePudding user response:

The second floor is the need for both transaction connect different database, said on the third floor of the data synchronization, try it

CodePudding user response:

reference lzp_lrp reply: 3/f

needed data in the database A synchronous to the oracle, and then retrieved

Moderator positive solution

CodePudding user response:

The oracle database access only query, how to make A synchronization in the past,

Thank you very much!!

CodePudding user response:

1. Set up two transaction, respectively connected to the access and oracle
2. Establish dw_1, connect to the access, pull out all the required fields, including to read data from the oracle (need) column way using the
3. Dw_1 retrieve the information
For ll_rown=1 to dw_1. RowCount ()
Ls_bh=dw_1. GetItemString (ll_rown, 'bh)//PRIMARY KEY
Select the required field INTO: ls_oracle_columns,...
The from ORACLE
Where the key=ls_bh;
Dw_1. SetItem (ll_rown, 'to display field, ls_oracle_columns)
Next
4. Is probably so