- This is not the released version of the documentation. Recommended Version
Data Modification
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 the Data Storing capability if you want to insert 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
-- Modification tool.
...
create modification.make
modification.modify ("Update CONTACTS set Firstname = ' John'")
- Commit your changes with your session control:
session_control: DB_CONTROL
-- Session 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