| Online Eiffel Documentation

EiffelStudio

# 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 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
      		-- 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