SQLIsRefined property

Applies to
TIB_Statement

Declaration
Property SQLIsRefined : boolean;

Description
Returns a flag that tells if the dataset is a result of a refined SQL statement.

This means that the dataset is only working with a smaller subset of records in order to avoid having to fetch all of the records from the server in order to be able to position the current record pointer onto a given record.

In the case of performing incremental searching it is possible to set up different parameters that allow a refined dataset to be defined before the actual incremental searching begins. Thus, if a user types "Wha" the dataset can be refined to only include records that are STARTING WITH "Wh" and then incrementally search upon thos records only. In this way the records starting with "A" to "V" will simply stay on the server and not be brought to the client.

This is part of how the SearchingLinks are handled. If they are defined then SQLIsRefined will always be true.