1. Andres Slachevsky
  2. PowerServer Web
  3. Friday, 18 May 2018

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
0
Votes
Undo

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

Comment
There are no comments made yet.
  1. Thursday, 1 August 2019
  2. PowerServer Web
  3. # 1
Alfredo Aldama Accepted Answer Pending Moderation
0
Votes
Undo
Hi, Can you put the code, only de header, the declaration of parameters. Regards
Comment
There are no comments made yet.
  1. Friday, 18 May 2018
  2. PowerServer Web
  3. # 2
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 18 May 2018
  2. PowerServer Web
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.