Class TDAOQueryDef (unit DAOQueryDef)

Inherits from

TDAODataset

TDAOQueryDef encapsulates a dataset with a result set that is based on a DAO QueryDef object.

Functions

procedure Execute;


function ParamByName(const Value: string): TParam;


Properties

property Active :


property FilterText :


property OpenType : TDAOQueryOpenType


property ParamCheck : Boolean


property Params : TParams


property QueryDefName : string


property SortText :


property ParamCount : Integer


property RecordsAffected : Integer


Functions

procedure Execute;

Executes the QueryDef.
Call Execute to execute the QueryDef with or without parameters.

function ParamByName(const Value: string): TParam;

To set input parameters at run time by name.
Example:
DAOQueryDef1.ParamByName('Customer_Id').AsInteger := 555;

Properties

property Active

TDAODataset.Active

property FilterText

TDAOQuery.FilterText

property OpenType : TDAOQueryOpenType

TDAOQuery.OpenType

property Params : TParams

TDAOQuery.Params

property QueryDefName : string

Indicates the name of the QueryDef that this component encapsulates.

property SortText :

TDAOQuery.SortText

property ParamCount : Integer

TDAOQuery.ParamCount

property RecordsAffected : Integer

TDAOQuery.RecordsAffected