Using Virtual Mode with Bound Sheets
Detailed instructions for using virtual mode are provided in Using Virtual Mode. However, if you are using virtual mode with a bound sheet, you should be aware that the following interactions might not behave as you would expect:
-
Querying the number of records
If you ask the data control how many records are in the database, it will tell you the number of records in the virtual buffer, not the number of records in the database.
-
Searching the database
If you search for data in the database, the data control will not look in every record. It will only look in records that are in the virtual buffer.
As a rule, using virtual mode with a bound fpSpread control limits the data control to working with only the information in the virtual buffer, not the entire database. Keep this in mind when designing interactions with the data control.