Powered by QM on a Rpi server
About OpenQM
Sales and Downloads
Help and Support

KnowledgeBase 00105: Non-Transactional Updates

Last updated: 25 Oct 2018
Applies to: All versions
Top level index       Full Index Search Tips
Previous article     Next article

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


Please tell us if this article was helpful
Very     Slightly     Not at all
Email (optional)