|
|
|
|
|
|
|
|
|
version 2004
PGSQL_GetValues (resID; fieldIndex; columnArray; startRow; rowCount)
| Parameter | Type | Description | |
| resID | Longint |  | Result ID returned by PGSQL_Execute |
| fieldIndex | Integer | | Field index |
| columnArray | Array |  | Array |
| startRow | Longint | | Row number from which column data will be returned |
| (default is 0) | |||
| Actual row number from which data is returned | ||
| rowCount | Longint | | Maximum number of rows expected |
| Actual number of rows returned |
Description
The PGSQL_GetValues command executes a bind between a PostgreSQL column data in a database cursor (selection) and a 4D array. You can detemine the maximum returned rows or from which row number the cursor will start to return data. The PGSQL_GetValues mechanism is 40 times faster than the usual process (in a 4D loop).
resID is a Longint that corresponds to the result ID returned by PGSQL_Execute.
fieldIndex the field index in the database cursor.
columnArray is a 4D Array (Integer, Longint, Real, Date, String, Text, Boolean) that will be bound with the corresponding column data.
In the startRow parameter, you pass the starting row number from which column data will be returned (default is 0). This parameter then returns the actual starting row number from which column data has been returned.
In the rowCount parameter, you pass the maximum number of rows you expect to be returned in the column array. This parameter then returns the actual number of rows returned in the column array.
|
|
|
|
|
|
|
|
|