KnowledgeBase 00105: Non-Transactional Updates

This article was originally published as a Tip of the Week.

Historically, few multivalue applications have made use of the transaction processing capabilities of the underlying database. Those that do sometimes encounter the need to apply an immediate update to a file within the scope of a transaction.

Opening a File for Non-Transactional Update

The QMBasic OPEN and OPENPATH statements both have an optional NON.TRANSACTIONAL qualifier. Any updates applied using the file variable returned from these operations will be applied immediately and do not form part of any currently active transaction.

Because the updates become non-transactional, rolling back the transaction will not undo the changes.

Related Articles

None.