January 26, 2015, 02:14 PMEnigma006
MODIFY null record
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?
January 26, 2015, 03:11 PMeric.woerle
I would just filter out the records WHERE X.FIELD IS NOT MISSING before the modify statement.
January 27, 2015, 03:22 AMAlan B
If 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 ' ';