Hi
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