Command Syntax
JQLCOMPILE(Statement, Command, Options, Messages)
Synatax Elements
Statement : is the variable, which will receive the compiled statement (if it compiles); most other functions use this to execute and work on the result set etc.Command : is the actual jQL query that you want to compile (such as SELECT or something similar). Use RETRIEVE to obtain fetchable data records, as the verb rather than an existing jQL verb. This will ensure that the right options are set internally. In addition, use any word that is not a jQL reserved word as the verb and it will work in the same way as RETRIEVE: implement a PLOT command that passes the entire command line into JQLCOMPILE and the results will be the same as if the first word were replaced with RETRIEVE.
Option: To supply a select list to the JQLEXECUTE function specify JQLOPT_USE_SELECT; the compile builds a different execution plan if using select lists.
Messages: If the statement fails to compile, this dynamic array is in the STOP format, and therefore you can program and print STOP messages, which provides a very useful history of compilation for troubleshooting purposes. It returns -1 if a problem was found in the statement and zero if there was not.
0 comments:
Post a Comment