INDEX ON flag FOR FLAG = 0 tag FLAG_TAGThen
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.