NOT NULL

vladsn07 · Post by **vladsn07** » Wed May 24, 2017 10:28 pm

How to set the value blank when deleting data, now the value is set to NULL? The attribute of the field is not NULL.
Failed to execute SQL: UPDATE [dbo]. [We_computers_all] SET [FriendlyName] = NULL, [Description] = NULL ...

yinsw · Post by **yinsw** » Thu May 25, 2017 12:55 am

That is your database design problem. If you allow the field to be empty or blank, it should not be set as NOT NULL.

By right, PHPMaker will set the NOT NULL fields as a required so you should not be able to save it as NULL. There is a setting in Tools -> Advanced Settings -> Validate NOT NULL fields.

vladsn07 · Post by **vladsn07** » Thu May 25, 2017 4:13 pm

It does not help, I need to insert a null in the field, but an empty value. Now if you delete the value, the value NULL appears

yinsw · Post by **yinsw** » Fri May 26, 2017 11:27 am

Maybe you have to do your checking in row_updating. Try this if it works?

if (!isset(rsnew["YOURVARIABLE"])){
$rsnew["YOURVARIABLE"] = "";
}

vladsn07 · Post by **vladsn07** » Fri May 26, 2017 12:42 pm

Has changed a little:
If (! Isset ($ rsnew ["YOURVARIABLE"]))) {
Everything works fine, thanks.