Then I suspect that your only solution is to follow Brigitta's suggestion and add to a temporary file, then when the user is happy, move the records to the final file.

The records you add as you are currently doing are going to be visible, but I believe they will be locked (un-updateable) until you commit. You might want to try updating one with SQL. What your existing programs do with locked records is something to consider.


On 1/1/2020 2:20 PM, smith5646midrange@xxxxxxxxx wrote:
That caused the STRSQL session to hang and eventually abend with a record in

This can't be the answer because most of the other programs using the files
will not have any form of commitment control. I am only adding it to this
program so the users can cancel their changes and rollback.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.