Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP scripting?
Message
From
02/04/2007 13:22:08
 
 
To
02/04/2007 13:16:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01211369
Message ID:
01211372
Views:
13
>I have a form with EditBox and few buttons and I am hoping that I can run my form and type in my SELECT statement in the EditBox and I would be able to Query my table in my testdbase.dbc according to my SELECT statement that I have typed in the EditBox. Is this possible? Please help. Thanks, Sam

You could do it different ways. One is with the use of the ExecSript() function.
Or you could use a memvar to capture the query text and build and run a query.

Be aware though that it is a major security hole and you should validate the heck out of any user input before submitting the query to the database.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform