USE newdnc order flag AGAIN && AGAIN never hurts, but it can save you frustrations later.. :-) if seek(0) 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>hi,
>>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 >>>>
>>>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.