SQLQuery from Component Store Ltd


Summary

  • TDataSet descendant (use all database-controls)
  • Replaces BDE and SQL Links
  • Commit control
  • TSQLQuery always returns a read-only result set
  • Implicit row based posting of updates via TSQLUpdate
  • Minimizes use of SQL Server connections
  • Retains most properties/methods of TQuery and TUpdateSQL
  • No OCX:s or DLL:s (except for MS SQL Servers driver ntwdblib.dll and protocol drivers).
  • Minimizes application footprint and startup times.
  • Uses Delphis:s fields editor.
  • High performance!
  • Works with D3 Standard and Professional as well as Client Server version.
  • Full blob support

VCL-classes:

TSQLServer - connects the queries to a MS SQL Server. Methods for commit control.

TSQLQuery - A query component that executes passthru SQL-statements. It can also cache all records in the record set and drop the server connection thus making it an ideal solution for applications with a large number of clients. The dataset is read-only and updates are performed thru the TSQLUpdate component.

TSQLUpdate - Updates tables on the server. The updates are triggered on every post event on the corresponding TSQLQuery component.

Go to SQLQuery homepage

(c) Component Store Ltd 1998