Hi Ed.
Your suggestion works! But it means that Rushmore optimisation in VFP and FP for DOS work totally different making me redesign not only forms but also data access in my system. It may not be good.
Sincerely, Igor Gelin
>Only FOR expression is Rushmore optimizable, i.e., if you have tag on ENUM, try to run COUNT FOR Enum<=lClaimto
>>I ran listed below small programm in VFP 5.0 and it took 94 seconds !!! In Foxpro 2.5 for DOS it took only 3 seconds !!!
>>The programm and tables are located on a network drive.
>>Please, help me to find a reasonable explanation of this mistery.
>>
>>Sincerely, Igor Gelin, System Developer
>>
>>
>>SET EXCL OFF
>>lClaimFrom="800700"
>>lClaimTo="806300"
>>nTotal=0
>>
>>Select 0
>>USE ("f:\ENCO") ALIAS INST INDEX ("f:\ENCONUM")
>>
>>Set NEAR ON
>>Seek Alltrim(lClaimFrom)
>>Set NEAR OFF
>>nTemp=Seconds()
>>Count For !Deleted() While ENUM <= lClaimTo To nTotal
>>Wait window Str(Seconds()-nTemp)+"seconds."
>>
>>Use In INST
>
Igor Gelin
Database Developer