I'm guessing that indexing on DELETED() is your problem. Records marked for deletion are ignored by commands, but NOT by the index (and therefore RUSHMORE). Just for laughs, try getting rid of the DELETED tags and try it again.
Phillip
>>This is a wild ass guess, since it's not obvious why it wouldn't be rushmore optimized, but have you checked sys(3054,11) to see if it gives you more information?
>
>Yes, something like "using deleted()..." and "Optimization: partial". I just messed a bit too much with the database and won't be able to reinstall it till later in the day. I can be more precise then but the idea is that only the deleted tag is being used.
Phillip Grant
Grant Computer Consulting
731.642.2162
phillip@grantcomputer.comBrainBench Certified: Visual FoxPro, RDBMS Concepts