commit

void sqlDataManager.commit ( String table ) (professional and enterprise editions only)

Description

Commit a prepared row of data into queue. Once called the data can no longer be edited. When working with multiple tables that relate by a foreign key, it is important to commit rows in the correct order. The rows in each of the child tables should be committed before the parent, or they will not be correctly linked when written to the database.

This does not write the row of data to the database, but rather puts it in queue to be written at a later time.

Parameters

  • table Name of the database table that the data corresponds to, as a string.

Return Values

Returns void.

Change Log

Version Description
5.0 Available for professional and enterprise editions.

Examples

Commit Database Row

 // Get datamanager
 dm = session.getv( "DATAMANAGER" );

 // Add session variables into person table
 dm.addSessionVariables( "person" );

 // Create and add query to buffer
 dm.commit( "person" );

See Also

  • flush() [SqlDataManager] - Writes committed rows to the database
  • commitAll() [SqlDataManager] - Commits all prepared rows of data to the queue to be updated in the database