RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TCustomSQLDataSet.PSSetCommandText Method

Assigns a specified SQL command to be executed by PSExecute.

Pascal
procedure PSSetCommandText(const ACommandText: WideString); override;
C++
virtual __fastcall PSSetCommandText(const BSTR ACommandText);

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. 

 

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!