• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • SQL Error (SQLSTATE=23502) - Assignment of a Null value to a Not Null Column

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

Resolved SQL Error (SQLSTATE=23502) - Assignment of a Null value to a Not Null Column

  1. Issue
0
Votes
Undo
  1. PremKumar Mani
    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)
SQL Error.jpg SQL Error.jpg
PBVersion as condition for conditional compilation
Richtext Control - Font Colours
Responses (1)
Chris Pollach @Appeon
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.