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!