Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Emergency Problem! If Select-SQL fail to find....
Message
From
13/03/1998 10:32:04
 
 
To
12/03/1998 07:47:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00084096
Message ID:
00084453
Views:
29
>
>create cursor testdbf (dummy c(10))
>cursorsetprop("Buffering",1)         && No buffering
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform