Database.ExecuteSQLStatement

Executes a SQL statement against the current data source for this database.

public string ExecuteSQLStatement(string SQLStatement,
	Values ParametersCollection);

Return Value

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.

Parameters

SQLStatement
The SQL statement to execute.

ParametersCollection
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.

Overloads:


See also:

Class Database
© Stonefield Software Inc., 2023 • Updated: 06/06/16
Comment or report problem with topic