Re: File read and sort question

Susan Ator wrote:

I have no control over 1) file naming 2) file inclusion in the directory 3) file removal from the directory This is all being handled through another program written in C. So far I have been able to put the relevant info from each file into the database then display with a simple order by. Now, I'm attempting to get the correct flow for checking if the file is in the database but not in the directory so I can delete it from the database. Trial and error. Susan

You have 2 possibilities: - empty the daabase before (or after) each run - create an index on RELEASE_DATE and RELEASE_TIME and use REPLACE, but RELEASE_DATE and RELEASE_TIME must be unique