/ doc / tocInheritance / QueryExpression / QueryExpressionStrict / __TOCDet / Description

Description

Edit keys at this level only

= Describes -Strictness- ON / OFF when executing query. 0x000D0x000ASpecified through -QueryExpressionStrict- and stored in -CurrentStrictness-.0x000D0x000ADoes not affect query result, only whether query will terminate or not due to perceived inconsistencies in the data.0x000D0x000A0x000D0x000AA typical example where you may want to set 'STRICT OFF' is when you have queries results where sometimes a specific field is not set, and that field is used in a subsequent query expression, for instance 'WHERE' or 'ORDER BY'.0x000D0x000AThis is because -QueryExpression does not have any concept of schema / 'supposed to exist' fields, it only sees the actual data.0x000D0x000AExample: If you have this:0x000D0x000A  Customer/42/FirstName = John0x000D0x000A  Customer/42/LastName = Smith0x000D0x000A  Customer/43/FirstName = Ann0x000D0x000AThen the query   "Customer/WHERE FirstName = 'Ann'/ORDER BY LastName'"0x000D0x000Awill fail because -QueryExpressionOrderBy- will not see any field 'LastName'.0x000D0x000AThis query0x000D0x000A  "Customer/WHERE FirstName = 'Ann'/STRICT OFF/ORDER BY LastName'"0x000D0x000Aon the other hand will succeed.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

Generated 2025-06-18 08:05:36.096 UTC