SQLSET Verb
Syntax
SQLSET(sqlchan{,ERR=lineref})int,expr{,int,expr...}
Description
The SQLSET verb loads the optional arguments that appear in the command string from SQLPREP. The sqlchan parameter is the SQL channel number. For each pair, int is the argument number and expr is the value to place. Arguments start at 1. The SQL arguments take effect in the SQL command on execution of SQLEXEC and may be set or reset any number of times prior to the execution of SQLEXEC.
Examples
0100 LET A=SQLUNT
0110 SLQOPEN(A)"Chile Company"
0120 SQLPREP(A)"Select lastname from customer where
0120:curr_bal>? and sales_region=?"
0130 LOOP:
0140 INPUT "Min balance>",B
0150 INPUT "Sales Region>",SR$
0160 SQLSET(A)1,B,2,SR$
0170 SQLEXEC(A)
0180 GOSUB FETCH
0190 GOTO LOOP
0200 FETCH:
0210 LET RESULT$=SQLFETCH(A,ERR=LOOP)
0220 PRINT RESULT$
0230 GOTO FETCH