Using Arithmetic Expressions with Arrays
From InterBase
Go Up to Accessing Arrays
Arithmetic expressions involving arrays can be used only in search conditions. For example, the following code fetches a row of array data at a time that meets the search criterion:
for (i = 1; i < 100 && SQLCODE == 0; i++) { EXEC SQL SELECT ARR[:i] INTO :array_var FROM TABLE1 WHERE ARR1[:j + 1] = 5; process_array(array_var); }