SELECT * FROM newdnc WHERE flag=0 into cursor curTemp if _tally>0 thisform.text4.Value=curtemp.char2 thisform.text7.Value=curtemp.char3 thisform.text6.Value=curtemp.char4 thisform.text8.Value=curtemp.char5 thisform.text5.Value=curtemp.char6 else =MESSAGEBOX("not found") endif>hi all,
>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.