Reading Data from an Array
From InterBase
Go Up to Accessing Array Data
There are seven steps required for reading data from an array or slice of an array:
- Create a
SELECT
statement that specifies selection of the array column (and any other columns desired) in the rows of interest. - Prepare an output
XSQLDA
structure to hold the column data for each row that is fetched. - Prepare the
SELECT
statement for execution. - Execute the statement.
- Populate an array descriptor with information describing the array or array slice to be retrieved.
- Fetch the selected rows one by one.
- Read and process the array data from each row.
Topics
- Creating the SELECT Statement to Read from an Array
- Preparing the Output XSQLDA to Read Data from an Array
- Preparing the SELECT Statement to Read Data from an Array for Execution
- Executing the Statement to Read Data from an Array
- Populating the Array Descriptor
- Fetching Array Data from Selected Rows
- Reading and Processing the Array Data