>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!
Robin,
Use sys(2015) to create filenames not sys(3).
PS: Novell admin might need to run purge at times if not setup to auto purge at intervals - that slows down the system too even the files are deleted.
Cetin