This topic has not yet been rated - Rate this topic

Statement.executeUpdate Method

Dynamics AX 2009

Dynamics AX 4.0

Executes a SQL INSERT, UPDATE, or DELETE statement.

Copy


public int executeUpdate(str statement)

Run On

Called

Parameters

Parameter	Description
statement	The string that contains the SQL statement being passed to the database.

Return Value

An updated row count; otherwise, 0 (zero) for SQL statements that return nothing.

Remarks

SQL statements that return nothing, such as SQLDDL statements, can also be executed.

If users control input to the executeUpdate method, an SQL injection thread can occur. Therefore, this method runs under Code Access Security. Calls to this method on the server require permission from the SqlStatementExecutePermission Class. The following are safer alternatives for interacting with the database:

Record level security is not enforced on the Statement class. If data is exposed to the user, perform explicit security validation.