General information
Category:
Coding, syntax & commands
Title:
Private data sessions and transaction
Greetings again comrades -
Background: I have a private data session in my form, but shockingly enough <g> have bombed out a few times in the middle of something. I'd tried to cancel the debugger, cancel the form, and fix the problem. Sometimes I could and sometimes I couldn't (many attempts at clear all, close all). It seems I'd often end up with several data sessions and sometimes Unknown data session .
Today after one such episode I found that I got a "Data mismatch error" when trying to do an append in a form which had previously worked. After attempting to look at the database I got a message to the effect that this wasn't permitted in the middle of a transaction. It finally dawned on me that some of those datasessions were in the middle of transactions, and I had to go to them and do a rollback to set things right.
So here are my questions: 1) How do you close out a private data session when this happens (i.e. is there another way besides what I did)? 2) Since it was a private data session, I don't understand why I'd get that message about transactions unless I was in that data session when I tried that maneuver. 3) Is Transaction not scoped (if that's the correct phrase) to the private datasession?
Thank you for any information you can provide,
Sylvia
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only