|Powered by QM on a Rpi server|
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.