Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wierd Things
Message
From
08/02/2002 11:30:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00611936
Message ID:
00617444
Views:
17
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform