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

Wild guess: Use myFile shared Koen

Op di 15 dec. 2020 om 19:00 schreef MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com>

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

-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

---

[excessive quoting removed by server]