hi,
thank you,
best regards
m.qasem

>

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