Even with SET TABLEVALIDATE TO 0, I was *still* getting the Error 108 on the simple INSERT INTO (lcFile) command. In the Exception WHEN event, I added a WAIT WINDOW TIMEOUT 1 "Retrying" and then reissued the call to the same method (ala recursion).
Testing now....
On 8/1/2020 12:44 PM, Jürgen Wondzinski wrote:
Ouch. Some old memories :) Glad to be indirectly helping!
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Freitag, 31. Juli 2020 23:43 An: profox@leafe.com Betreff: Re: VFP9SP2 Error 108: File is in use by another user.
Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend.
I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE.
Thanks for the lead, Frank!!!
On 7/31/2020 4:11 PM, Frank Cazabon wrote:
I haven't used dbfs in years and can't say I've ever got this error but this might help:
[excessive quoting removed by server]