We use sys(15) to generate unique filenames as well and we stumbled on something weird. If you write a program that print unique filenames for a couple of seconds you will see that duplicates will occur. We solved it by creating our own sys(15) function that has a .05 seconds delay. With this modification no duplicates have been created.

Ron

>Hi! I create several temporary file names in FPD26, which I delete when I'm finished. I use the unique file name SYS() which creates a 8 digit number.
>
>The programs have become a bit sloppy & don't always delete these files when they should. To get around this as part of the batch thats run every night a remove any dbf with a purely numeric file name.
>
>My customers novell 5 file server grinded to a go slow recently, it turns out that foxpro FPD26, or FPW6 has been creating D1234567.dbf files. These files had hit a limit IE D9999999.dbf, and once we got rid of the higher number the files the system speed cleared up again.
>
>Q1: Why does Foxpro create unique file names as D1234567.dbf
>
>Q2: How does it pick which number to use IE why is there such gaps between the numbers?
>
>Q3: why did this cause a problem, does it take Foxpro forever to find a number if the maximums been used?
>
>Hope this makes sense!