INDEX ON flag tag FLAG_TAG

>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