Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Like expression
Message
From
06/09/2000 19:43:21
 
 
To
06/09/2000 19:38:27
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00413252
Message ID:
00413254
Views:
19
>Hi there! I use LIKE expression in SQL Path Trough. But Vfp does’ not understand this expression. And tell “Command contains unrecognized phrase/keyword”. Here it’s:
>_cliptext = _cliptext + IIF(EMPTY(lcbui_adr),'', ' and bui_adr like '%Serycheva%')
>Please help.

If this was copied and pasted, looks like you're missing an end quote in the bolded part above.
Try this instead
_cliptext = _cliptext + IIF(EMPTY(lcbui_adr),'', " and bui_adr like '%Serycheva%'")


HTH
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform