Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exclamation sign is removed in parameter substitution
Message
From
14/10/2005 15:05:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Exclamation sign is removed in parameter substitution
Miscellaneous
Thread ID:
01059262
Message ID:
01059262
Views:
48
Run code like the following with your backend:
private cstr
cstr='b'
sqlexec("SELECT * FROM test WHERE ?cstr!='a'")
There must be no space between r and !

note that the actual query passed to server is
SELECT * FROM test WHERE 'b'='a'
VFP replaces != condition to = condition.

Please confirm, can anybody reproduce this ?
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform