Skip to content

    IProviderSupport.PSExecuteStatement

    Execute a SQL statement.

    Declaration

    Source position: db.pas line 1637

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

    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.

    See also

    Name Description
    PSGetCommandText
    PSSetCommandText
    PSExecuteStatement