Focal Point
MODIFY null record

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8157054476

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


8.1.05
HTML,PDF,EXL2K, Active, All
January 26, 2015, 03:11 PM
eric.woerle
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
Oracle 11.2.0.2
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 ' ';



Alan.
WF 7.705/8.007