[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]

Reference for unit 'DB' (#fcl)

IProviderSupport.PSExecuteStatement

Execute a SQL statement.

Declaration

Source position: db.pas line 1415

function IProviderSupport.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

Declaration

Arguments

Function result

Description

See also