Using Host Variables in Array Subscripts
From InterBase
Go Up to Accessing Arrays
Integer host variables can be used as array subscripts. For example, the following cursor declaration uses host variables, getval
, and testval
, in array subscripts:
EXEC SQL DECLARE TC2 CURSOR FOR SELECT CHAR_ARR[1], INT_ARR[:getval:1,1:3] FROM TABLE1 WHERE FLOAT_ARR[:testval,1,1] = 111.0;