Hi all experts,
*I assume that 1st connection = Default connection (active connection)*
In my window object (name="w_update"), I has one DataWindow Control (use 2nd connection : "trans_list" : name="dw_con_list") that some column in this DataWindow Object I have set it to Editable with "DropDownDW" and point to "dw_customer" object (This object use Default connection : SQLCA). Then problem is occurred... In "w_update"'s "open" event, I have these code in
trans_list = create Transaction
trans_list.dbms = "ODBC"
trans_list.autocommit = true
trans_list.dbparm = "ConnectString='DSN=eCM;UID=;PWD='"
CONNECT USING trans_list;
When I open the window then PB warn me...
Select Error : SQLState=S0002
Microsoft Jet Database Engine can not find the input table or query 'table_name'. Make sure it exists and spell correctly.
*In design time I can't retrieve all DataWindow object that use 2nd Connection, But In runtime I have created transaction object and SetTransObject() then It'll work fine. Can someone tell me that I'm going the right way? or wrong way?*
Can someone plz point me to the solution to solve all my confusing/suspecting...
Thanks very much & very much all experts,
Here is my only one hope.