Question: How to obtain a correct number of records in TpFIBDataSet?


Answer: FIBPlus works with the server at the level of SQL queries. The server does not return the record number to the client after the SELECT query, because all the records are retrieved one after another by the Fetch method. 
In practice we know the number of records fetched only when the server reports that there are no more records in the query result after the regular Fetch.
The simplest thing you can do to obtain the correct number of records in the TpFIBDataSet is to use the poFetchAll option. After opening the query you should check the RecordCount value (it will be correct) or to use the psAskRecordCount option. If psAskRecordCount = True, then after opening SelectSQL TpFIBDataSet will automatically execute a supplementary query "SELECT count(*)" in order to make the server report about the record number.
This mechanism does not guarantee correct work because the COUNT() use is restricted by InterBase/Firebird features.
Besides sometimes FIBPlus cannot convert the main query from SelectSQL (it can be very complex) into a simple query which will only get the record number.
Such a behaviour is common for any InterBase/Firebird library.


Preview text: 
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



What a good job you did! Keep coding great pieces of fast and efficient software:) We started using FIBPlus back in 2001. Since then, every project we offer uses FIBPlus to connect to FirebirdSQL. You library has always been stable, flexible and rocket fast ! Our major project, an helpdesk/data mining application, concurrently used daily by more that a hundred technicians and analysts, uses FIBPlus. Now that FirebirdSQL 2.0 is available, we have been able to upgrade our application quickly and painlessly - that's another reason you can be proud of your work ! >>

Benoit Le Bourhis, Adhoc Innovations
FOR CUSTOMERS
Download full versions and updates in your Personal Area