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