Hi all,
Error 108: You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a networkI get this error and I don't see how it would happen based on this scenario. The error does not happen too often - maybe five times a year.
Use MyTable IN 0 alias MyTable again shared
Insert into MyTable (fld1, fld2) Values (NextId(), "Hello World")
function NextId()
local nNextId
nNextId = -1
cAlias=alias()
use MyId in 0 alias MyId again shared
go top
if rlock()
replace nextid with nextid + 1
nNextId = nextid
unlock
endif
use in select('MyId')
select (cAlias)
return nNextId
Environment:
1. MyApp.exe runs on several MyAppServers. There are at least 25 instances of MyApp.exe running.
2. Data resides on MyDataServer.
3. At any given second, there can be at least 5 queries, updates or inserts (any or all) against MyTable.
4. SET REPROCESS TO 2
What preventive code should I put in - probably before the INSERT statement? I don't want to use the AutoInc functionality as the tables are before that version of VFP.
ramil
~~ learning to stand still