Thanks Stephen, I was hoping there is a way to programatically access the functionality include in the Query Builder. - apparently not.
Thanks again, Joe On Fri, Feb 19, 2016 at 12:48 PM, Stephen Russell <[email protected]> wrote: > On Thu, Feb 18, 2016 at 11:15 PM, Joe Yoder <[email protected]> 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. > > > > > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CABQeDnUBaciQj=j1-4fkevyhhta_nkch2o16yfkx9muwqy1...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
