SET Limitations

Following are important limitations to observe when constructing a SET statement.

Only simple fields may be referenced in a SET statement.
To determine how many SETs can be in a query, use the following formula:
(18 x Number of Tables Joined) + (Length of SORT key)

+ (17 x Number of SET Statements) + 6

= (A Number That is Less Than 760)
There is an absolute maximum of 43 SETs for a query with a FIND on one table and no SORT statement.
The Found Table record size (768) limits the number of combined SET statements and sort keys that can be used in a query.
SQL DATE, TIME and TIMESTAMP cannot be used with DQL SET, SORT and WITH.
A numeric column whose value can be zero should not be used as a divisor in a SET statement or an arithmetic expression.
The maximum numeric precision is 18 digits.
An arithmetic expression cannot have more than five levels of nested parentheses.
A SET statement cannot have more than 10 levels of nested parentheses.