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

cached: 12/14/2017 8:38:59.000 PM