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

cached: 09/22/2017 10:16:26.000 PM