v60SQLNullableBehavior

The v60SQLNullableBehavior build descriptor option affects how EGL behaves when a null value is assigned to a variable.
Starting with version 7, EGL throws a SQL Exception in the following circumstances:

If the v60SQLNullableBehavior build descriptor option is set to NO, this behavior does not change.

If the v60SQLNullableBehavior build descriptor option is set to YES, non-nullable variables are set to blank or 0, depending on their type.

Values

NO
When an SQL query returns a null value that is assigned to a variable for which the isSQLNullable property is not set to YES, EGL throws a SQL Exception.
YES
In the same circumstances, EGL sets the variable to 0 or a blank.

Default value

The default value of v60SQLNullableBehavior depends on the vagCompatibility build descriptor option:
  • If vagCompatibility is set to YES, the default value for v60SQLNullableBehavior is YES.
  • If vagCompatibility is set to NO, the default value for v60SQLNullableBehavior is NO.

Manually setting the option

In most cases, you should not need to manually set the v60SQLNullableBehavior build descriptor option.


Feedback