# JQLEXECUTE

Updated: 10/14/2021, 2:20:00 PM
Created: 10/14/2021, 2:20:00 PM
Last Updated By: mikes
Read Time: 1 minute(s)

Tags: record handling query language

# Description

JQLEXECUTE starts executing a compiled jQL statement. It takes the general form:

JQLEXECUTE(Statement, SelectVar)
1

Where:

  • Statement is the valid result of a call to a JQLCOMPILE
  • SelectVar is a valid select list used to limit the statement to a predefined set of items. For example:
SELECT PROGRAMMERS WITH IQ_IN_PTS > 250
LIST PROGRAMMERS NAME
1
2

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.

For a practical example of use, see the jexport.b program in the $JBCRELELEASEDIR/samples/JQLBASIC directory.

Go back to jBASE BASIC

Go back to Programmers' Reference Guide