613-518-1166 info@zimdatabases.com

ZIM Language Reference

SET CHECKNULLS

< All Topics

Controls required field checking for EntitySets and relationships with fields.

Syntax

SET CHECKNULLS ON|OFF

Comments

The CHECKNULLS option is set ON by default.

When CHECKNULLS is ON, an error results if a Required field is assigned the $Null property during an ADD, CHANGE, INSERT, or UPDATE command. Normally, you should always leave CHECKNULLS set ON.

Even if you switch null checking OFF, you should always explicitly or implicitly assign some value to every required field.

Note: A field is Required if its definition in the Object Dictionary specifies yes for Reqd.

See Also

ADD

CHANGE

INSERT

UPDATE

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents