Thank you

I have this proplem if you can help

I have a grid, I get data from table(trans1) into grid1
On click(in a grid) I write this code
select 2
use trans1
locate for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
if found()
set filter to upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
replace flag with 1 for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
endif


sometimes it works and I have "1" in the field(flag)

when I try again I have nothing "0"in the field(flag)…….why if you can help



Remark:-

On AfterRowcolChange(in a grid) I write this code

thisform.text1.value=price

thisform.text2.value=nam1

thisform.text5.value=nam2

thisform.text3.value=nam3

thisform.text7.value=no

thisform.text10.value=sale



thisform.text3.value=thisform.text4.value



with thisform.Grid1

.Recordsource = .Recordsource

endwith



thisform.grid1.refresh