January 26, 2015, 02:14 PM
Enigma006MODIFY null record
Hello
I have a HTML input form to input data and update database from it. I am using MODIFY statement.
A null record is being entered into database if values are not entered in a record on the form. How can I avoid this?
Thanks
January 26, 2015, 03:11 PM
eric.woerleI would just filter out the records WHERE X.FIELD IS NOT MISSING before the modify statement.
January 27, 2015, 03:22 AM
Alan BIf the data is coming in from an HTML form, then I guess that the record is just blank values.
VALIDATE can be used to control whether a transaction takes part in MATCH processing:
VALIDATE ACCEPT_TEST = fielda NE ' ' OR fieldb NE ' ';