>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?

Looks like you could just use a cursor for this, then no delete problems...