type DMLResult

A DML result for a field annotated with @dbquery. When a field annotated with @dbquery has type DMLResult then its SQL statement is assumed to be a data-change statement (e.g. INSERT, UPDATE, DELETE) that does not return a result set.

Fields

lastInsertId: ID

value generated by the database in response to a SQL statement execution. Typically this will be from an "auto increment" column when inserting a new row. Not all database types this field, and the syntax of such SQL statements varies.

rowsAffected: Int

number of rows affected by an data-change statement (UPDATE, INSERT, or DELETE). Not every database type may support this.