An SQL engine implemented in a TDataSet descendant component, that can parse SQL syntax, and that will use that syntax to query to another TDataSet, or a group of TDatasets in order to get a result set. Works very similar to TQuery that comes with Delphi. The main difference rely on the fact that TxQuery dataset can query to any TDataSet descendant component, and that way, can be used with BDE alternatives that don't implement the SQL language.You can query a TTable, a TQuery, TADODataSet,TADOTable, TFFTable, THalcyonDataSet, or any otherdataset descendant component, including Text andMemory datasets. The SQL syntax supported by TxQuery is more like Local SQL supported in Delphi and is a subset of SQL-92 specification (like Local SQL).
|