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

I would just filter out the records WHERE X.FIELD IS NOT MISSING before the modify statement.

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 ' ';