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);
}

Advance To: