There is no SYS(3054)in FPD. Perhaps if the index was created in FPD and you are opening the table in VFP, then the old index is not fully optimized as far as VFP's implementation of Rushmore.
>Foxpro dos 2.6 table indexed on a single field.
>When I run select * from this_table where indexed_field ='Some_Value'
>Sys(3054,1)says it is partially optimized. What is wrong I am doing.
>I dropped & recreated the index.Even Packed and reindexed table many times. The funny thing is that the same table and same query when run on another computer shows fully optimized.But when the same table is used on the form, and when the form is opened, then it says there is no rushmore optimization.
>
>Sanjay Chavda
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05