SQL::ResultSet FetchPage Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/FetchPage Method.xml
Fetch a block of one or more rows into a local cache table. Note: This function is an advanced user feature and requires some understanding of caching for SQL.
sql_cachefetchpageeventscript Function
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/sql_cachefetchpageeventscript Function.xml
Get the script for Events related to the ResultSet::FetchPage function.
Function Topics
/documentation/pages/Index/Function List.xml
Page links to functions.
SQL::ResultSet ExecutePostProcess Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/ExecutePostProcess Method.xml
Execute portable SQL against a *[xb:SQL::ResultSet]*, Allows for filtering after fetching a result set.
SQL_ResultSet_Preview Function
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/SQL_ResultSet_Preview Function.xml
Numeric
SQL::ResultSet NextResult Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/NextResult Method.xml
Position to the next set of rows in the ResultSet (applies only when multiple results are returned).
SQL::ResultSet NextRow Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/NextRow Method.xml
The NextRow() method fetches the next row in the SQL::ResultSet.
SQL::ResultSet ToXML Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/ToXML Method.xml
Convert ResultSet an XML formatted string.
SQL::ResultSet ColumnNumber Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/ColumnNumber Method.xml
Get the number of the column named.
SQL::ResultSet GoToRow Method
/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/GoToRow Method.xml
Position to the row requested (backward movement is not supported by all databases).