PB error handling with null values when inserting into DB
Posted on 2003-03-25
here is the scenario:
PB 8.0.3 Build 9704
I have a table where fields are defined as "not null".
When i insert NULL in one of this field, no error is fired (without message) on Powerbuilder side and the record is not inserted.
When i do the insert into SQL Plus i got an error!
Why PowerBuilder doesn't handle this error?
What have to do to catch this error? Is that a bug?
Ok what i can do, before inserting, check if the values are given! But when i forgot to check one value and then this value is null, i will never find the error because no errormessage is fired.