IProviderSupport.PSExecuteStatement function

Member of IProviderSupportIn unit DB

Execute a SQL statement.

Declaration

pascal

function PSExecuteStatement(const ASQL: string; AParams: TParams; 
 ResultSet: Pointer=Nil): Integer

Arguments

`ASQL`	SQL statement to execute (may contain parameters).
`AParams`	Parameter values to substitute when executing ASQL.
`ResultSet`	Pointer to resultset (if any).

Function result

True if the statement ASQL was executed successfully.

Description

PSExecuteStatement will execute the ASQL SQL statement in the current transaction. The SQL statement can have parameters embedded in it (in the form :ParamName), values for these parameters will be taken from AParams. If the SQL statement returns a result-set, then the result set can be returned in ResultSet. The function returns True if the statement was executed successful.

PSExecuteStatement does not modify the content of CommandText: PSGetCommandText returns the same value before and after a call to PSExecuteStatement.

IProviderSupport.PSExecuteStatement function

Declaration

Arguments

Function result

Description

See also