Bde.DBTables.TQuery.ExecSQL

• Up to Parent: TQuery

Delphi

procedure ExecSQL;

C++

void __fastcall ExecSQL(void);

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	Bde.DBTables.pas Bde.DBTables.hpp	Bde.DBTables	TQuery

Description

Executes the SQL statement for the query.

Call ExecSQL to execute the SQL statement currently assigned to the SQL property. Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE).

Note: For SELECT statements, call Open instead of ExecSQL.

ExecSQL prepares the statement in SQL property for execution if it has not already been prepared. To speed performance, an application should ordinarily call Prepare before calling ExecSQL for the first time.

See Also

• Open

• Prepare

• SQL

• Executing the Commands using TSQLDataSet

• Using TQuery