Use the DB_CHANGE class to perform any operation on your database that does not require access to a result. You can for instance modify table row content, drop table rows, create and delete tables.
Note: Take a look at theData Storing capability if you want toinsert table rows.
DB_CHANGE allows you to modify the database data using the SQL language:
- Prepare your SQL query and use modify:
modification: DB_CHANGE
...
create modification.make
modification.modify("Update CONTACTS set Firstname = ' John'")
- Commit your changes with your session control:
session_control: DB_CONTROL
...
session_control.commit
Tip: It is always better to check the database status for errors before committing changes.
See Also
Data storing
Stored procedures
Implementation