Working in Autocommit Mode

Restriction: This topic applies to Windows environments only.

When SQLWizard is installed on your machine, the default setting for data entry transaction processing is Autocommit On. In this mode, all changes made to a record are committed as soon as you move to the next record. This means that you do not have to remember to commit periodically, and it frees any locks that might be held on records you are editing, so that other users have access to the data. However, it means that you have little chance to rollback changes.

For this reason, SQLWizard provides two undo commands. The Undo command in the Edit menu restores changes to the current field. The Undo command in the Record menu re-reads the current record from the database. Since the record changes were never written to the database, there is no need to perform a rollback. However, you cannot use the Undo command once you have left the modified record.