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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only