VCL Components
COMPONENT LIBRARY FOR PROGRAMMING LANUGAGES
  HOME  |   NEW  |   POPULAR  |   TOP RATED  |   AUTHORS  |   CONTACT US  |   LINK TO US  |   SUBMIT  |   SEARCH

Languages

 TServerCountQuery 1.0

Version: 1.0 Shareware By: Francesco Pucino
Downloads: 0   Hits: 131 Source: YES report broken broken link report
Sponsored Links:


Description of TServerCountQuery :
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.
Package: Price:
Without source $39
Source included $0
Download DOWNLOAD NOW!
Info MORE INFO!

User Reviews:

Write Review *
Your name *
Email *
(Your comments will be reviewed by our staff before they are posted)
Rate this product *

 

Related:

 OleDb Direct 1.73

OLEDB Direct Components Suite allows direct access to OLEDB interfaces from Borland (c) Delphi and C++ Builder. OLEDB Direct Components Suite is a...

Shareware By: Viatcheslav V. Vassiliev

 TPictPreview 1.03 1.03

TPictPrev 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...

Shareware By: Istvan Mesaros

 AidAim SQLMemTable 2.10

SQLMemTable 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...

Freeware By: AidAim Software

 ADOAccess 1.0

Demo utility for working with mdb-files via ADO (source code):Enumerating tables, view columns name and type, view records,Executing SQL query,...

Freeware By: Vladimir Afanasyev

 DeZign for databases v2.4

Dezign for databases is a database development tool using an entity relationship diagram. It visually supports the lay out of the entities and...

Shareware By: Rick van Dijk

 TGPS 1.11

Interface with your GPS receiver.

Shareware By: Axolot Data

 TMetastock 1.00

Read and write Metastock quote files.

Shareware By: Axolot Data

 XLSReadWriteII.NET 2.00

XLSReadWriteII.NET for Delphi 2005/2006 and others, Win Forms Use this version for creating Win Forms applications with Delphi, Visual Studio and...

Shareware By: Axolot Data

 Syndicate Pro 1.0

Syndicate Pro multi-platform compatible. Syndicate Pro is server software for managing and distributing news headlines and other content over the ...

Shareware By: Sujit

 pgISQL (Interactive SQL for PostgreSQL) ver. 2.2.0 2.2.0

Interactive SQL for PostgreSQL is a powerfull database utility. It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL...

Shareware By: Sujit

New Component

Popular Component

© Copyright 2000-2008 VCL Components All trademarks are the sole property of their respective owners.
Usage Policy - Privacy Policy - Link To Us
Contact: