General information
Category:
Coding, syntax & commands
Hi, Bonnie.
A couple of questions for you.
1. Is the table bound to a grid control?
2. If you don't cancel the add, but save it instead, can you cause the same error?
3. In your cancel button, what exactly do you do? A tablerevert, I imagine. If when you get the error, if you do a tablerevert on the table, what happens?
4. Are you using private or default datasessions?
I don't ever use pessimistic buffering, but since PB sets a lock as soon as editing begins and doesn't release it til the changes are committed or reversed, then I'd look at the point where I think my code is releasing my editing session.
I don't know if that helps any. :-(
>Hi folks! Got another weird one! I'm getting Error #108, "File is in use by another". What the docs tell me is that this error is generated by an attempt to "USE, RENAME or DELETE" a file that is being used by another user on the network. Well, that isn't the case here ... I'm the only one working on this.
>
>It's an intermittent error, it seems to be happening on a permanent table, not a cursor, and it's happening when I attempt to INSERT INTO. From the command window I also tried an APPEND and got the same error. But, when I USE'd it to close it and USE'd it again to open it back up, no problem, the error wasn't generated. I'm using Pessimistic Row buffering (so there's no table-locking or file-locking that I'm aware of).
>
>It happens when I attempt my "add" code on my form more than a few times (I hit the "Add" button, then "Cancel" it and do this a few times and then the error finally fires).
>
>Any ideas?
>
>TIA,
>Bonnie
Previous
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