Excuse my ignorance but I am green in this mobile app world.
Is it possible to have two transaction object connected in an mobile app?
I will be connecting to QRemote (Quickbooks Driver) and SQLAnyWhere 17.
Could you please show me a sample code or direct me to the right place or the document where I can research.
Regards,
Clarence
If you need another transaction object ...
1) Declare a new one in your App (ie Global Pool)
Transaction go_clarence
2) In the open event of your App's Application object, instantiate the TO.
go_clarence = CREATE Transaction
3) Load the appropriate DB connection values in the 2nd TO
go_clarence .DBMS = "ASE"
go_clarence .Server = "????"
go_clarence .LogID = "Chris"
go_clarence .Password = "Its_a_secret"
....
4) Now connect to the 2nd DBMS or DB instance as usual .
Connect using go_clarence ;
5) Set your DWO's to use the new TO
DC.SetTransObject ( go_clarence )
6) If you have "inline" SQL for the 2nd connection, change your "using" clause.
Select Pay_amount into :MyVar from Payroll using go_clarence;
HTH
Regards ... Chris
Thank you very much. It is working without any issues.
I am connecting with QB database via QREMOTE and Sybase SQLAnyWhere 17 and it is working very good.
Regards,