postgreSQL.cursor.fetchAllRows
Syntax
postgreSQL.cursor.fetchAllRows (cursorRef, adrRows, ctRows, as, flCoerceToUserTalkTypes)
Params
cursorRef is a reference to a cursor as returned by postgreSQL.cursor.create.
adrRows is the address of the variable where the result will be stored.
as is an optional string4 value indicating the desired result type. Default is listType.
flCoerceToUserTalkTypes is an optional boolean indicating whether PostgreSQL values in the rows should be converted to corresponding UserTalkTypes. Default is true.
Action
Fetch all remaining rows from the last result set generated by a query or procedure call.
Returns
A boolean that is true if at least one row was fetched, or false if there are no more rows waiting to be fetched.
Examples
postgreSQL.cursor.fetchAllRows (cursorRef, @rowList, recordType)
« true //rowList now contains e.g. {{"first":"Ian", "last":"O'Sullivan", "age":48}, {"first":"Bull", "last":"Mancuso", "age":41}}
Notes
This verb is equivalent to calling postgreSQL.cursor.fetchMultipleRows with the ctRows parameter set to the number of remaining rows in the result set.
See Also
postgreSQL.cursor.executeQuery
postgreSQL.cursor.executeMultipleQueries
postgreSQL.cursor.callProcedure