Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function to return what VFP will do to my code?
Message
From
14/12/2018 14:57:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
CodeMine
Title:
Function to return what VFP will do to my code?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Database:
Visual FoxPro
Application:
Desktop
Virtual environment:
VMWare
Miscellaneous
Thread ID:
01664494
Message ID:
01664494
Views:
109
Hi all,

Don't even know what to search for - I thing I remember seeing a function that does this. Basically, I want to know what VFP is going to do with my code when I set a filter e.g.

SET FILTER TO State = 'NY'

when I query FILTER(), it returns STATE="NY"

i.e. it strips out the spaces and changes my single quotes to double.

Why do I need this? In one form I want to only fire the SET FILTER statement if the user has changed something. But my worked up filter string is always going to be different than what VFP returns via FILTER(). Especially something like:

SET FILTER TO State = "NY" OR State = "PA"

becomes this with FILTER()

STATE="NY".OR.STATE="PA"

I am sure I saw a function for this at one point.

Albert
Next
Reply
Map
View

Click here to load this message in the networking platform