>>if seek(5, "TableAlias", "myCheckNumber ")
>> locate for myId = 3 and between(myDate, dDate1, dDate2) while myCheckNumber = 5
>>endif
>
>Hmmm.. Using both FOR and WHILE ? I really doubt if rushmore kicks in here and uses the MyId index. I'd rather choose for making a composite index if speed really is a requirement.
I would agree in some situations. If this is a once a year routine that will only take a few seconds, I wouldn't worry about it. But if it is something used more frequently, a composite index might would make more sense.
As always, different situations call for different solutions.
Take care,
Joe
Joseph C. Kempel
Systems Analyst/Programmer
JNC