>
>create cursor testdbf (dummy c(10))
>cursorsetprop("Buffering",1)
>insert into testdbf values ("Test0")
>cursorsetprop("Buffering",5)
>insert into testdbf values ("Test1")
>insert into testdbf values ("Test2")
>insert into testdbf values ("Test3")
>select * from testdbf where dummy="Test"
>tableupdate(2,.t.,"testdbf")
>select * from testdbf where dummy="Test"
>select testdbf
>1
>replace dummy with "Notest"
>select * from testdbf where dummy="Test"
>tableupdate(2,.t.,"testdbf")
>select * from testdbf where dummy="Test"
>
>Cetin
Thanks Cetin! Now, I know what happen!!!!!!!!!
The problem was post by me BY Mistakes!!!!!!!!
Today, I have post a message about
Keypress and Interactivechange!!!!!!!!!!!!!!!!
when leaving the office, I wonder that the Keypress event
still count the F11 key input as CHR(nKeyCode) when
key in at the Textbox........ ~~~"_"~~~
Actually, my coding joking myself......
As previously, I use Form.keypress with set Form.KeyPreview to .t.
to find the F12 key to finish add row short Cut!!!
But F11 key mean NkeyCode = 133 is +ve and have been added into
CHR() of textbox when this.value = this.value + chr(nKeyCode).....
So, an Unseenable Character has appended at the end of field.......
Surely fail in search............
as table.field will append SPACES if no enough!!!
the last search become where "1434-FG039AA " = "1434-FG039AA~ "
where ~ is invisible in character!!
I wonder this manual bug when I len(alltrim()) and counter the difference!!
Oh Lord, I nearly go crazy now.......
AnyWay, posting this message is to awake ppl to take care when
using Coding in Keypress Event........ +_+"
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.