Description
It's a discendent of standard TQuery. It allows to fix the (very) slow method to count result records used in the standard query component: fetch each record from the server and store it on the client, increasing a counter... If you use local DBMS as Paradox or dBase you don't are afflicted by poor performances, but if you use DBMS server as MS SQL Server or Oracle, each time your code call the RecordCount method you assist to HD light flashing, network traffic increasing and a very long response time.More results are in the query recordset, more problems you have... More time you use the RecordCount method on the same query, more time you have the problem...TServeCountQuery solve the problem, asking directly to the DBMS the number of records retrieved: fast, easy and clear. You can use this component as a standard TQuery component, all the work is done in background and if some error occours, will be fired an OnCountError event and the standard RecordCount method will be called. You can access too to the LastCountSQL string propery to see the SQL statemant used to retrieve the record count in the current query.
Related:
User Reviews:
Related:
OleDb Direct 1.73OLEDB Direct Components Suite allows direct access to OLEDB interfaces from Borland (c) Delphi and C++ Builder. OLEDB Direct Components Suite is a... |
Shareware |
TPictPreview 1.03 1.03TPictPrev is a component to display images. The images can be loaded / saved from / in files and from / in strames. This way it can be used also...By: Istvan Mesaros |
Shareware |
AidAim SQLMemTable 2.10SQLMemTable is a fast and easy-to-use in-memory table and query components library for Delphi and C++ Builder. It does not require BDE and provides...By: AidAim Software |
Freeware |
DeZign for databases v2.4Dezign for databases is a database development tool using an entity relationship diagram. It visually supports the lay out of the entities and...By: Rick van Dijk |
Shareware |
TPictPreview 1.01 1.01TPictPrev is a component to display images. The images can be loaded / saved from / in files and from / in strames. This way it can be used also...By: Istvan Mesaros |
Shareware |
XLSReadWriteII.NET 2.00XLSReadWriteII.NET for Delphi 2005/2006 and others, Win Forms Use this version for creating Win Forms applications with Delphi, Visual Studio and...By: Axolot Data |
Shareware |
TGPS 1.11Interface with your GPS receiver.By: Axolot Data |
Shareware |
pgISQL (Interactive SQL for PostgreSQL) ver. 2.2.0 2.2.0Interactive SQL for PostgreSQL is a powerfull database utility. It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL...By: Sujit |
Shareware |
Syndicate Pro 1.0Syndicate Pro multi-platform compatible. Syndicate Pro is server software for managing and distributing news headlines and other content over the ...By: Sujit |
Shareware |
ESBPCS for VCL 4.2.2ESB Professional Computation Suite (ESBPCS for VCL) provides a huge collection of Borland Delphi Routines and Components to make Data Entry and...By: Glenn Crouch |
Shareware |
