1. Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 18 May 2018 12:53 PM UTC

We have a Store procedure declare as a Local External Function in the Transaction object 

function long pr_generar_codigo(decimal cod_parametro,ref decimal next_serial_no) RPCFUNC ALIAS FOR "sbp.pr_generar_codigo"

in the update strart of the datawindow we have this code

  SQLCA.pr_generar_codigo(parametro,codigo)     

Codigo is declare as a decimal instance variable

in execution (in Appeon 2016) the when it reach the line it stop the execution of the event and all the lines after the calling are not executed, it return no erros and no error in the Appeon log.

as a workaround we did the following:

decimal ll_codigo 

  SQLCA.pr_generar_codigo(parametro,ll_codigo)     

codigo = ll_codigo 

and it solve the problem 

 

leoxmar adrian gomez Accepted Answer Pending Moderation
  1. Thursday, 1 August 2019 21:53 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

alguien sabe como invocar un stored procedure  de postgres desde power builder 

Comment
There are no comments made yet.
Alfredo Aldama Accepted Answer Pending Moderation
  1. Friday, 18 May 2018 20:15 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2
Hi, Can you put the code, only de header, the declaration of parameters. Regards
Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 May 2018 13:32 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Hi Andres;

   This sounds like a product bug. Please open a Support Ticket for this issue.

I am glad though that you found an easy work around though .. and, thanks for sharing!

Regards ... Chris

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.