MyDAC

TCustomDASQL Members

TCustomDASQL class overview.

Properties

Name Description

ChangeCursor

Enables or disables changing screen cursor when executing commands in the NonBlocking mode.

Connection

Used to specify a connection object to use to connect to a data store.

Debug

Used to display executing statement, all its parameters' values, and the type of parameters.

FinalSQL

Used to return a SQL statement with expanded macros.

MacroCount

Used to get the number of macros associated with the Macros property.

Macros

Makes it possible to change SQL queries easily.

ParamCheck

Used to specify whether parameters for the Params property are implicitly generated when the SQL property is being changed.

ParamCount

Indicates the number of parameters in the Params property.

Params

Used to contain parameters for a SQL statement.

ParamValues

Used to get or set the values of individual field parameters that are identified by name.

Prepared

Used to indicate whether a query is prepared for execution.

RowsAffected

Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.

SQL

Used to provide a SQL statement that a TCustomDASQL component executes when the Execute method is called.

Methods

Name Description

Execute

Overloaded. Executes a SQL statement on the server.

Executing

Checks whether TCustomDASQL still executes a SQL statement.

FindMacro

Searches for a macro with the specified name.

FindParam

Finds a parameter with the specified name.

MacroByName

Finds a Macro with the name passed in Name.

ParamByName

Finds a parameter with the specified name.

Prepare

Allocates, opens, and parses cursor for a query.

UnPrepare

Frees the resources allocated for a previously prepared query on the server and client sides.

WaitExecuting

Waits until TCustomDASQL executes a SQL statement.

Events

Name Description

AfterExecute

Occurs after a SQL statement has been executed.
© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback