1. Louis Mancini
  2. PowerBuilder
  3. Wednesday, 5 June 2019 19:25 PM UTC

Hi,

 

Recently migrated older PB12 code to PB 2017 R3 and also tried the new PB 2019 have this issue.

 

Powerscript code stops after the execution of an embedded stored procedure.  None of the powerscript code after the stored procedure runs in executed.  This use to work fine.  DB is MS SQL server

Any way to fix this.

 

Thank You.

 

Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 June 2019 08:01 AM UTC
  2. PowerBuilder
  3. # 1

Hi Louis,

Please add ",PBNewSPInvocation='yes'" at the end of SQLCA.DBPARM before connecting and see if it works.

If there’s still the issue, please help to provide a test case to us for more
study.

Regards,
ZhaoKai

Comment
  1. Michael Kramer
  2. Thursday, 6 June 2019 13:32 PM UTC
I have stored procedure calls working just fine in PB 2017 R3. Both using embedded SQL and using RPCFUNC declarations. Both using pass-by-value and pass-by-reference parameters.

As ZhaoKai points on, when SQLCA is configured correctly there should be no issues doing this.
  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.