Having a weird situation at one site. My app is used by approximately 70 people on 25 different serves. At one site everyone is having a consistent problem with one peice of code (not the exact peice of code, but very close):

query1 = sys(3)
select * from collat.dbf into table (query1)
USE (QUERY1) IN 0 ALIAS QUERY1
QUERY = 'E'+SUBSTR(SYS(3),2,7)+'.DBF'
SELECT QUERY1
COPY TO (QUERY)
USE (QUERY) IN 0 ALIAS QUERY
SELECT QUERY
USE IN QUERY1
DELETE FILE(QUERY1) && File not found

The DELETE FILE (Query1) gets a consistent file not found. In explorer, I can see many sys(3) file names that have not been deleted in their root directory. I execute the exe from my workstation and it works fine (netware 32, i have a different context and different prefered server).

This is the only place in the app that it sys(3) and then DELETE FILE. At almost all others it sys(2015). The other sys(3) use an ERASE.

Only thought is that I know this site had some problems with he system clock. Does sys(3) use the system clock to generate its unique number? What system clock does it use over the network, workstation or preferred server?

Anyone have any thoughts on this?

Brenda