The following code examples show how to use data modification statements.

Procedure for Updates

You can use sqlQuery method to execute data modification statements.

INSERT

To insert updates:

sqlQuery("INSERT INTO incident (priority) VALUES ('4')")

UPDATE

To retrieve updates:

sqlQuery("UPDATE incident SET priority = '4' WHERE category = 'request'")

DELETE

To delete updates:

sqlQuery("DELETE FROM incident WHERE sys_id = 'S'")