NexusDB query component.  Default values are shown in the object inspector snapshot.

Icon

nxQuery1

Properties and Events view

DelphiGuide_nxQuery1 DelphiGuide_nxQuery1(a)

Purpose

Similar to a TnxTable component, TnxQuery can be linked to a TnxDatabase and TnxSession and specify a table name for explicit connections or simply link to a session and by using an alias name, create an implicit database component.  This component is mostly compatible with the BDE's TQuery; for embedded apps it requires an TnxSQLEngine linked to the server engine.  The functionality is limited by the SQL 2003 standard and is most commonly used for complex joins, reporting and bulk updates.

Key Properties

RequestLive

Allows live (editable) datasets to be requested. If the engine can't return a live dataset, the data returned is read-only, irrelevant of this property.

Sql

the query statement

Home | Site Contents | Documentation | NexusDB Manual V4 | Delphi Guide | VCL Component Overview | TnxDataset Group