RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TCustomCachedDataSet.CommandText Property

Specifies what data to fetch from the database server.

Pascal
property CommandText: WideString;
C++
__property BSTR CommandText;

CommandText specifies what data the client dataset wants to receive from the server. By default, this is an SQL statement (query) for the database server to execute, but each TCustomCachedDataSet descendant can override this property to allow other types of commands. 

If CommandText includes parameters, use the Params property to supply parameter values.

Note: If the FileName property is set, CommandText is ignored and the data is fetched from the specified file.
Warning: Do not remove poAllowCommandText from the Options property. If you do, the value of CommandText will be ignored.
 

 

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