Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved How to handle two transaction object in a mobile app

  1. How-to
0
Votes
Undo
  1. Clarence Chamorro
    Clarence Chamorro
  2. PowerServer Mobile (Obsolete)
  3. Wednesday, 13 February 2019 14:13 PM UTC

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

  1. PowerServer Mobile
QODBC database driver
AndroidManifest.xml file
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 February 2019 16:18 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 1

Hi Clarence;

   Yes, you can have many TO's in your Web or Mobile Apps!PB acutally supports up to 255 of these in one App. That being said - the highest I ever got in one App was 12 (one for each province in Canada plus two territories - at the time).

It's easy to do ...

1) Define the various "Data Sources" you require in PowerServer via the AEM console.

2) In your Web/Mobile App's PowerServer Toolkit "profile" define as many extra TO's as you need.

3) Re-deploy the App(s) after adding the extra TO's.

HTH

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 13 February 2019 20:38 PM UTC
Hi 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

  1. Helpful
Clarence Chamorro
  1. Clarence Chamorro
  2. Sunday, 10 March 2019 15:09 PM UTC
Sorry not to reply to your help.

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,
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 11 March 2019 16:58 PM UTC
Super ... that is excellent news Clarence! :-)
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.