RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
IProviderSupport.PSSetCommandText Method

Assigns a specified SQL command to be executed by PSExecute.

Pascal
procedure PSSetCommandText(const CommandText: string);
C++
__fastcall PSSetCommandText(const AnsiString CommandText);

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) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!