Yes, now you mention it I went through the same maze years ago, and gave up.
It's amazing how so much of vfp stuff (the bits we can see) is so opaque, but other parts are elegant and clear - almost anything from Calvin /Hsia for example./

On 22/02/2016 17:34, Dave Crozier wrote:
Andy,
I had a look for it in xSource some time ago. The Wizard is there but it is 
that convoluted it would be quicker to rewrite it!!!. It is all linked in to 
the Wizard framework that M$ used and it is like unravelling spaghetti!

Dave

-----Original Message-----
From: ProFox [mailto:[email protected]] On Behalf Of AndyHC
Sent: 22 February 2016 11:25
To: [email protected]
Subject: Re: Including an SQL expression builder on a form

Isn't it in xsource?

On 20/02/2016 01:15, Joe Yoder wrote:
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/[email protected]
** 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.

Reply via email to