Hi again Mohammed,

reading what you needed to do in this case, I suggest you use an index of flag, skip the 'for flag=0'.

>Hi
>How many distinct values flag column can have?
>from 1 to 9
>can the index work with 1 to 9
>

>
>INDEX ON flag FOR FLAG = 0 tag FLAG_TAG
>

>thanks.
>
>>How many distinct values flag column can have?
>>
>>If flag can only have 0 and 1 values(or few distinct values), is not recommended to have an index without good selectivity, because Rushmore will use it even if is not necessary.
>>
>>Maybe the better solution is to have, if you only need a quick access to records with flag=0, a filtered index with "FOR flag = 0" as filter clause
>>

>>INDEX ON flag FOR FLAG = 0 tag FLAG_TAG
>>

>>
>>Then
>>

>>USE newdnc
>>set order to TAG_FLAG
>>go top
>>if not eof()
>>    thisform.text4.Value=char2
>>    thisform.text7.Value=char3
>>    thisform.text6.Value=char4
>>    thisform.text8.Value=char5
>>    thisform.text5.Value=char6
>>else
>>    =MESSAGEBOX("not found")
>>endif
>>set order to 0
>><pre>
>>
>>
>>
>>>hi all,
>>>
>>>i have table with more than 10,000 records, at network(many users).
>>>
>>>i need to found record with flag=0,to get all information at myform
>>>
>>>i useto locate to finde it as under,maybe somthing else faster.
>>>any idea
>>><pre>
>>>USE newdnc
>>>LOCATE FOR flag=0
>>>if found()
>>>    thisform.text4.Value=char2
>>>    thisform.text7.Value=char3
>>>    thisform.text6.Value=char4
>>>    thisform.text8.Value=char5
>>>    thisform.text5.Value=char6
>>>else
>>>    =MESSAGEBOX("not found")
>>>endif
>>>

>>>thanks.
>>>m.qasem