JQLEXECUTE

JQLEXECUTE starts executing a compiled jQL statement.

COMMAND SYNTAX

    JQLEXECUTE(Statement, SelectVar)

SYNTAX ELEMENTS

Statement is the valid result of a call to a JQLCOMPILE (Statement, ...)

SelectVar is a valid select list used to limit the statement to a predefined set of items. For example - how it's used in jQL (note the ">") prompt: 

     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 an incorrect statement variable. It will cause the statement to run against the database and produce a result set for use with JQLFETCH().

Last update: Sat, 16 Jul 2022 15:34