Using Host Variables in Array Subscripts

From InterBase
Jump to: navigation, search

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;

Advance To: