jBase Query Language JQLEXECUTE

JQLEXECUTE starts executing a compiled jQL statement.

Command Syntax

JQLEXECUTE(Statement, SelectVar)

Syntax Elements

Statement is the valid result of a call to JQLCOMPILE(Statement, …).
SelectVar is a valid select list that used to limit the statement to a predefined set of items.

Example

: SELECT PROGRAMMERS WITH IQ_IN_PTS > 250
1 Item Selected
> LIST PROGRAMMERS NAME

PROGRAMMERS...  NAME
0123            COOPER, F B

This function returns -1 in the event of a problem, such as the statement variable not being correct. It will cause the statement to run against the database and produce a result set for use with JQLFETCH.