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

Resolved Dynamic transaction object to data source mapping

  1. Issue
0
Votes
Undo
  1. Saroj Mungtaweepongsa
    Saroj Mungtaweepongsa
  2. PowerBuilder
  3. Friday, 7 July 2017 08:25 AM UTC

Hi,

I tried to implement about Dynamic transaction object to data source mapping. I have 2 Data Sources , one is connected to my local machine database, another is connected to remote database. Both Data Sources succeeded testing connection.

I follow the PowerServer Help file.

My code is very simple.

ON w_main : Open Event

These code will got DataWindow error.

    

 

  If comment out like this, it's still retrieved data from my local database.

 

These code, the PowerBuilder IDE can retrieve data from Remote DataBase , but mobile app still got DataWindow Error.

  

 

Thanks,...  Saroj

  1. PowerServer Mobile
Question about native PDF
PB 2017 Mobile
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 7 July 2017 15:49 PM UTC
  2. PowerBuilder
  3. # 1

Hi Saroj;

   Yes, you must use the Connect command to reroute your SQLCA changes to your PowerServer. PowerServer is where the actual connection to your target DBMS is being done. In Appeon Web and Appeon Mobile - your Web/Mobile PB Apps are using PowerServer's DB connection feature at run-time not native PB's (akak run-time).

   Also, don't forget to check your return codes after every DB and/or DW operation.

HTH

Regards ... Chris

Comment
Saroj Mungtaweepongsa
  1. Saroj Mungtaweepongsa
  2. Monday, 10 July 2017 03:20 AM UTC
Thank you, Chris.



Do you have any example code of the Connect command to reroute SQLCA changes to PowerServer for MS SQL Server. I could not find these in any documents. I tried many ways to do it, but still failed.



 



Thank you so much......  Saroj



 

  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.