Data.DB.TDataSet.PSSetCommandText

From RAD Studio API Documentation
Jump to: navigation, search

[–] Properties
Type:
procedure
function
Visibility: protected
Source:
Data.DB.pas
Data.DB.hpp
Unit: Data.DB
Parent: TDataSet

Delphi

procedure PSSetCommandText(const CommandText: string); virtual;

C++

virtual void __fastcall PSSetCommandText(const System::UnicodeString CommandText);

Description

Assigns a specified SQL command to be executed by PSExecute.

If the provider's Options property includes poAllowCommandText, clients can supply an SQL command along with a call to GetRecords or Execute. This command is passed to the dataset by a call to PSSetCommandText, and subsequently executed by a call to PSExecute.

The value of the CommandText parameter replaces the dataset's SQL statement (if it has one), or replaces the name of an underlying database table or stored procedure.

This method is an implementation of the IProviderSupport.PSSetCommandText method and, by default, is blank. To use it, every TDataSet descendant must override it in its specific way.

See Also