Trying to restate what you are doing to test my comprehension:
you want to delete all the records in close_merchant2 where the last_dep date is greater than 60 days before some start date.
So if the last_dep is two months or more before the startdate, you want to save the record, otherwise it gets the axe (deleted).
Do I have it down? I don't see a problem with that logic. And that seems like exactly what the program will do. If you have a trashed cdx file, wierd things can happen, have you tried rebuilding the indexes from scratch?
>I have some code that looks like this.
>
>USE close_merchant2 IN 0 EXCLU
>SELECT close_merchant2
>DELETE ALL FOR last_dep >= (dStartDate - 60)
>GO TOP
>DELETE ALL FOR EMPTY(last_dep)
>USE IN close_merchant2
>
>As you can see, i do a calculation on the last_dep and dstartdate. For some strange reason I get a differnet last_dep date than the one that comes in the data. For example, the last_dep date ends up being something in June when the file clearly states it as being something in January. This last_dep date entry is never changed. It is used only to calculate what needs to be in teh table. Is this from table corruption? Do I need to reindex the tables involed to make sure they have good stuff in them?
--Todd Sherman
-Wake Up! Smell the Coffee!