Focal Point
MODIFY null record

This topic can be found at:

January 26, 2015, 02:14 PM
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?


HTML,PDF,EXL2K, Active, All
January 26, 2015, 03:11 PM
I would just filter out the records WHERE X.FIELD IS NOT MISSING before the modify statement.

Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
January 27, 2015, 03:22 AM
Alan 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 ' ';

WF 7.705/8.007