logo
Powered by QM on a Rpi server

KnowledgeBase 00105: Non-Transactional Updates

Last updated: 22 Jul 2016
Applies to: All versions
Search  
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

None.



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