Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String question on search screen
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00110033
Message ID:
00110057
Views:
16
After looking a bit closer at your code. I see what's happening. If you change it as follows, the error shouldn't occur:
str3 = ""
IF NOT EMPTY(This.Value)
  str3 = "UPPER(Client.Surname) LIKE" + CHR(34) +;
  ALLTRIM(UPPER(This.Value)) + "%" + CHR(34)
ENDIF
This will save you the trouble of having to screen this character out, and allow for a smaller subset to be returned.

hth,
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform