3. FetchArray

[<<<] [>>>]

R = ODBC::FetchArray(DB,arr)

Use this function to fetch one row from the results after a successfully executed SELECT statement. The first argument to the function is DB the database handle. The second argument should be a variable. This variable will hold the array containing the data of the actual row. The array is indexed from zero to n-1 where n is the number of columns in the result set.

Use consecutive calls to this fucntion to get the rwos of the result one after the other. You can mix consecutive calls to FetchHash and FetchArray.

The function returns -1 (TRUE) if fetching a row of data was successful or 0 (FALSE) if there are no more rows in the dataset. In the latter case arr will be undef.

See also FetchHash

This function calls the ODBC functions SQLFetch, SQLDescribeCol, SQLGetData.

[<<<] [>>>]