On Thu, Feb 18, 2016 at 11:15 PM, Joe Yoder joe@wheypower.com wrote:
I am working on a form where I build a table with memo fields storing sql select statements and would like to use a built in VFP function, with all the field names and functions available, to build and edit the statements. The data the sql select will reference is in a pair of cursors. I found the query builder but I don't know how to access it from a form and it wants the name of a database with no obvious way to accept a cursor or free table.
Make array(s) to hold the date you want the user to see, drag, click on to be inserted into the text of the statement you are making.
Now for the bad news that you might have to protect users from doing wrong things, "Drop table Employees" or "Delete Customers" are just some of the issues at hand.