1. PremKumar Mani
  2. PowerBuilder
  3. Monday, 19 October 2020 15:03 PM UTC

I am facing an issue as shown in the attached screenshot. The issue occurs when generating an Excel Report. The same functionality is working in PB 8.0 but only in PB 2019R2 I am seeing this error. Requesting you to provide a solution to fix this issue.

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 19 October 2020 17:23 PM UTC
  2. PowerBuilder
  3. # 1

Hi PremKumar;

  Definitely a DBMS NULL based error. I would check your in-line SQL or the App DWO's "Update Properties" to ensure that ...

1) The Null column is indeed one that needs to be updated

2) Run through the debugger to see if your App's code actually initializes the column's value

3) Use an SQL Trace to to view more detail ..

   SQLCA.DBMS ="XXX"  // Current

   SQLCA.DBMS = "TRACE XXX"  // new

TIP: To see more SQL in the trace ...

   SQLCA.DBParm = "DisableBind=1"

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.