How to obtain a correct number of records in TpFIBDataSet?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
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.
When I had to find the best component to connect to my Firebird databases, FIBPlus imposed itself with its rapidity and reliability. Most importantly, it continued to evolve to be even better and whenever we had a problem, it was fixed promptly by Devrace team. We use FIBPlus in many projects related to Healthcare. We have hundreds of users who access databases up to 8 GB in size. I think there are many good third-party components out there, but not so many with an excellent support like the one provided for FIBPlus components. Thanks to you. >>Evelyne Girard, Canada
