1. Keerthana G
  2. PowerBuilder
  3. Tuesday, 27 August 2024 06:24 AM UTC

Hi,

I am using Powerbuilder 2019 and SQL Server to retrieve the data.

Issue: There is a datawindow and it gets rows retrieved from stored procedure. But the label & the data both are blank for specific screens in some terminals of customer sites only and they mentioned that it gets resolved on it own after few days.

Can anyone please advise on this issue cause that why would it happen?

I have attached the screen where the value are not null/empty but it does not display the column label & value. It is a compute field(Expression mentioned below).

Expression of the compute field:

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 August 2024 12:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Keerathina;

  I would agree with David in that the probable reason is because the SP is returning a NULL result set. However, I would also suggest dropping the expressions & replacing these with Display Format masks. In a DF,  you can set the mask to account for a "Null" & let the App user know that's what the DBMS is returning.

FYI ...  string-format ; null-format

  That way, you can show the App user that the actual value is a "null" (or say "nothing") vs displaying a blank value which is not intuitive. Just my $0.02.

Regards ... Chris 

Comment
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Tuesday, 27 August 2024 10:57 AM UTC
  2. PowerBuilder
  3. # 2

Hi

I'm sorry but I do not have a lot of help to offer..

Based upon what you have described and the computed field expression I would say that all the column values are Null. You can prove this by adding the columns themselves to the DW.Does the procedure work directly, can you create another DW using the procedure and does that work?

I'm not sure how it can fix itself after sometime unless the data has changed, is there any Font/Background colour expressions that are affecting the text colour?

Just some ideas to look at.

Hope it helps

David

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.