sqlNullable

The sqlNullable modifier is an optional modifier for a parameter in a function declaration. This is the older of the two methods that EGL offers to add a null flag to a variable. The null flag allows you to set a variable to a null value.

EGL maintains this modifier for compatibility with earlier versions. Best practice for new code is to use the "?" type extension character to indicate a nullable variable. For more information, see "Type extension characters."

Note that the sqlNullable modifier works like the isSQLNullable property, and that this behavior is different from that of the "?" type extension character. For details, see isSQLNullable.

The main use for the sqlNullable modifier is on a function parameter that corresponds to an argument that is sqlNullable (not a nullable type) and you want to be able to get/set the null status of that parameter within the function. In the following example, the call of fnctn2 is not valid because fnctn2's parameter has the inOut modifier, but the argument and parameter types do not match.
  function fnctn1( x int inOut sqlNullable )
    fnctn2( x );
  end

  function fnctn2( y int? inOut )
    y = null;
  end

Feedback