Dear cetin;



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