hi,
what you mean or how i can use skip the 'for flag=0'.
thanks alot.

>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