Overview

Library contains two components: TBDEClientQueryEh and TUpdateSQLEh

TBDEClientQueryEh component () inherited from TClientDataSet.

It provides almost all functionality of TQuery and adds several new features: 
Uses CachedUpdates of TClientDataSet (CDS), more fastly and does not create temporary files in contrast of TQuery.
Can use UpdateObject and OnUpdateRecord as in CachedUpdates mode as in not CachedUpdates.
Provides almost all features of CDS including:
    Sorting and indexing, 
    maintained aggregates,
    Flat-file database, 
    Local master/detail relationships.

If you don't know about TClientDataSet (CDS) then read 'Client datasets' topic in Delphi Help before using this component.


TUpdateSQLEh component () inheritted from TUpdateSQL.
It has new property - GetRecSQL of TStrings type.
TBDEClientQueryEh uses it property when calling TBDEClientQueryEh.RefreshRecord procedure. Property TUpdateSQL.GetRecSQL have to contain SELECT expression that return one record containing value for all fields of the current record. In most cases it property will contain a copy of TBDEClientQueryEh.SQL property with additional term '... and KeyField = :KeyField ' in WHERE clause.

Deployment applications, that use TBDEClientQueryEh component 

As you know applications that uses TClientDataSet need to deploy with DataSnap DLLs - Midas.dll. TBDEClientQueryEh based on TClientDataSet and therefore also need this DLL. However under Delphi 6 you can imbed this library to  executable file by writing Crtl and MidasLib units in 'uses' clause to any of your unit.

Download library:

You can download DBClique Library here: DBClique.zip.