>I have a direcectory of tables, one for each month (yyyymm.dbf), which I need to cycle through and delete all those older than 30 days.
>
>SYS(2000) would let me cycle through all files in the directory and check if each one is older than the 30 days but this seems a very inelegant way of solving this.
>
>Can anyone think of a cleaner way of achieving this?
You could use ADIR() to get an array of *all* the files in the folder; by default they're sorted alphabetically ascending, so you could just spin through the array deleting the topmost file(s) until anything older than your 30 day threshold is deleted.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up