Re: Error 108 - File is in use by another user on INSERT INTO line

I'll double-check it.  Pretty sure I set that to ZERO after the last time you guys recommended that.  ;-)

On 12/15/2020 3:41 PM, Jürgen Wondzinski wrote:

Hi Mike,

see HELP for SET TABLEVALIDATE. You either haven't set that setting (then the default value is 1+2) or you got it wrong :)

The "correct" value would be 1+4 = 5 or a plain 0

wOOdy

-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Dienstag, 15. Dezember 2020 19:00 An: ProFox Email List profox@leafe.com Betreff: Error 108 - File is in use by another user on INSERT INTO line

VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client

My error handling tripped on this simple line:

                      INSERT INTO broker!doclinks

(ifileid,idoctypeid,crange) VALUES (thisform.oFile.iid,liDocTypeID,ALLTRIM(loObj.txtRange.value))

VFP Help says this about Error 108:

 Visual FoxPro 9.0 SP2

 File is in use by another user (Error 108)

You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a network.

I don't see why this line of code would throw an Error 108. I guess I'll add a simple TRY/CATCH around it to retry it "N" number of times (via DO WHILE loop with flag and counter), but tossing this out to the group for your thoughts.

Thanks, --Mike