null Behavior

Note that in version 7 and earlier, the variable $null was used as the default for the NULL option (as it predated the NULL option itself). However, this left an important part of the behavior of a <sql> statement unspecified by the statement itself, and potentially dependent upon a variable assignment (<$null = ...>) forgotten elsewhere - such ambiguity could cause problems.

Thus, in version 8 and later, the $null variable has no effect on <sql> statements, and is repurposed as a constant with no values, for situations where that is useful (e.g. passing a no-values argument to a named parameter).

Copyright © Thunderstone Software     Last updated: Sep 25 2019
Copyright © 2020 Thunderstone Software LLC. All rights reserved.