Code Inside
Native Query expression is dealt as a normal peace of code.
Therefore, any language construction is legible inside:
- variables;
- temporary
objects created within a query;
- static
calls;
- exception
handling.
However, some restrictions do apply:
- NQ
should not be used to modify the database to prevent loops;
- NQ
should not use threads, as NQ are expected to be triggered in large
numbers;
- NQ
should be fast, therefore they should not interact with the GUI;
- NQ
should follow security restrictions, as they are executed in the server
and potentially can create malicious behavior there.
In a case of uncaught exception within a Native Query a null
result is returned.
For more info see
Native Query Collection