Skip to content

piFetchResult - cSQLStatement

Intended to be used with SQLFetchRowValues, where you get rows from a result set row by row.

Type: Property
Access: Read/Write
Data Type: Integer
Parameters: None

Syntax

Property Integer piFetchResult
Access Type Syntax
Read Access: Get piFetchResult to IntegerVariable
Write Access: Set piFetchResult to IntegerVariable/Value

Description

piFetchResult is intended to be used with SQLFetchRowValues, where you get rows from a result set row by row.

It behaves similar to Found. As long as you have successfully fetched a row from the result set, piFetchResult will be 1. When you have reached the end of the result set, piFetchResult will be 0.

SQLFetchResultsetValues returns a complete result set. All rows are fetched internal and piFetchResult will be set to 0 at the last fetch.