niota

Null and empty string values can be distinguished during grid edit as special cases.

In niota value “null” can be indicated with character '~'. In the case of text/varchar fields if a column is nullable and '~' is given as value on the edit-form, then “null” will be inserted into the database cell. Null indicator '~' can be used also in the case of nullable numeric fields. Lookup sets can be extended with additional “null” value. Check the help of the corresponding administrative menu item for further information: configure lookup

In niota value empty-string can be indicated with string “--”. In the case of text/varchar fields if “--” is given as value on the edit-form, then empty-string will be inserted into the database cell. Indicator character “--” can be used only in the case of textual fields (varchar, nvarchar, etc.).

Oracle database connection acts differently. In Oracle database environment “null” and empty-string value are not distinguished. Cell value can be null by using '~' character on the edit-form. But “--” string has no meaning in this context therefore “--” input is used as a valid text input.