Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Looking Up Records That have % in Field Data
Message
 
To
27/09/2008 03:37:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01350997
Message ID:
01351256
Views:
21
Hi Dennis,

>Will this SPT work if it is MySQL? Basically, what I am asking is if VFP functions (like ATC) can be recognized?

No, within an SPT string you have to use the syntax of the backend or the supported ODBC functions, eg.
SELECT * FROM table WHERE INSTR(field,'%')>0
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform