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" );