Statement.executeUpdate Method [AX 2012]

Executes a SQL INSERT, UPDATE, or DELETE statement.

public int executeUpdate(str statement)

Run On

Called

Parameters

statement
Type: str
The string that contains the SQL statement being passed to the database.

Return Value

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

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 . The following are safer alternatives for interacting with the database:

  • Queries

  • Views

  • X++ select statements

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

Community Additions

ADD
Show: