515 error in Powerbuilder 7.03

[NikhilGoel]

Hi:

We are facing a very strange problem in Powerbuilder-7.03. on one of the window with datawindow on it, we are getting 515 error for column person_id found null. Intresting thing is I can see the value of the column in the datawindow and still it is coming up with that error. We initially thought that it is something related to itemstatus in Powerbuilder, but that was not the case. The column person_id does has status as modified, but somehow still in the SQLPREVIEW event it is not showing up in the Insert statement. We tried, Regenaration, Export/Import, but still not solved. The other thing is this happens randomly. It will be a great help if someone has a clue how to resolve this error. Our backend database is Sqlserver-7.0.

Thanks

 

[daniel32]

If this is happening when you are attempting to save the datawindow, try dw_1.Accepttext() and see if that solves your problem. From what you said, it sounds like this is happening when you insert a row. AcceptText() will place a value in the buffer and should stop this error from happening.