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

Resolved PowerServer.WinAPI - Database configuration - Transaction

  1. Issue
0
Votes
Undo
  1. Chen Mey Lee
    Chen Mey Lee
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 22 February 2021 08:48 AM UTC

Hi ,

Defined below SQLCA transaction object in PowerBuilder 2021 (beta), this transaction object used to for multiple database connection during runtime :-

Below error return when try to access SQLCA transaction object (nvo_trx_info), look like the SQLCA is not recognize by WebAPI :-

PowerBuilder source code :-

WebAPI is running without any issue :-

 

 

Power

 

Error occur when using PowerBuilder 2021 to build...
PowerServer2021 Beta: SQL Select Error: Execution ...
Responses (3)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 February 2021 02:15 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Chen,

I did not reproduce the issue on our end. Please open a support ticket in the support portal, please provide a test case and the detail steps to reproduce the issue to us for more study, Many thanks in advance.
https://www.appeon.com/standardsupport/

Regards,
ZhaoKai

Comment
Chen Mey Lee
  1. Chen Mey Lee
  2. Tuesday, 23 February 2021 05:29 AM UTC
Bug 6131 created , Thanks.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 22 February 2021 13:19 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

for example I have 2 transaction objects in my application:

sqlca (which is associated to n_tr in the additonal variables in the applciation object)

and

it_debugTrans, which has been instantiated in my gnv_app as an intance variable named "it_debugTrans".

So in the configuration y specify:

one row for SQLCA and another row with "it_debugTrans"

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 22 February 2021 13:16 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

If "nvo_trx_info" is the name of an object and not a variable in which it has been instantiated, you have to use the variable name and not the object name.

regards.

Comment
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.