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

Resolved String field size per procedure

  1. How-to
0
Votes
Undo
  1. marco gaspar
    marco gaspar
  2. PowerBuilder
  3. Thursday, 27 October 2022 13:54 PM UTC

Good Morning!
I need to return a string value by a procedure in PB, but the data is not complete.
Is there any solution for this case?

Grateful.

Cryptography
Set application icon when building .exe with pbc17...
Responses (4)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 20:58 PM UTC
  2. PowerBuilder
  3. # 1

Is this a CURSOR in a PowerBuilder event or function?

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 15:17 PM UTC
  2. PowerBuilder
  3. # 2

Hi Marco;

  What happens when you run the SP from within the DB Painter's ISQL pane?

Regards ... Chris

Comment
There are no comments made yet.
marco gaspar
marco gaspar Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 14:55 PM UTC
  2. PowerBuilder
  3. # 3

Declare pr_desif_movimento Procedure For dbo.pr_desif_movimento @cd_posto = :al_cd_posto,
@data_ini = :adt_inicial,
@data_fim = :adt_final,
@json = :ls_json OUTPUT;

Execute pr_desif_movimento;
Fetch pr_desif_movimento Into :ls_json;
If sqlca.sqlcode = -1 then
Rollback;
guo_trata_erro.uf_trata_erro()
Return 1
End If
Close pr_desif_movimento;

 

ls_json -> In this variable, it does not return the total amount that comes from the bank.
A part is missing.

Comment
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 28 October 2022 13:10 PM UTC
Have you checked whether the missing value is set / available in the stored procedure itself. I mean, is the value (total amount) is set in the SP. May be on some conditions that value is not set. Can you verify that?
  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 14:47 PM UTC
  2. PowerBuilder
  3. # 4

It would help if you gave us some details.

Are you talking about a database stored procedure? If yes, what database?

How long was the string you attempted to return and how long was the part that made it through?

 

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.