Executes a SQL statement against the current data source for this database.
public string ExecuteSQLStatement(string SQLStatement, Values ParametersCollection);
If the SQL statement failed or some error occurred, the return value is blank. If the SQL statement doesn't create a result set (for example, a SQL UPDATE or INSERT statement), "1" is returned. Otherwise, the return value is the result set as an attribute-based XML string.
The SQL statement to execute.
If you use a parameterized SQL statement or call a stored procedure that receives parameters, ExecuteSQLStatement needs a source for the values of the parameters.
See also:Class Database
© Stonefield Software Inc., 2018 • Updated: 06/06/16
Comment or report problem with topic