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.
Any advice will be welcome.
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
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.
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 srussell705@gmail.com wrote:
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.
-- 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]
Joe,
There are several 3rd party plug-in SQL builder products for VFP. I can't think of their names at the moment, but perhaps this comment will trigger someone else's memory.
Malcolm
Query Maker was one - seems it's still available: www.hallogram.com/qrymkr/
I tried it years ago but found it too complicated for what I wanted. I ended up building a simple one using the picker class (samples or foundation classes??) for users to run against un-normalised views that I created.
On 20/02/2016 02:00, Malcolm Greene wrote:
Joe,
There are several 3rd party plug-in SQL builder products for VFP. I can't think of their names at the moment, but perhaps this comment will trigger someone else's memory.
Malcolm
[excessive quoting removed by server]
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 srussell705@gmail.com wrote:
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.
-- 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]
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
Yes, Calvin and also John Koziol were excellent coders but I just couldn't get on with Ken Levi's programming style - a little like his speaking style i.e. all enthusiasm and disconnected jumping from subject to subject. Steven Black certainly writes great neat structured code, which raises the discussion what makes a good developer... Maybe food for another thread!!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 15:55 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
I'll add Andy Kramek and Marcia's coding style into the good pot also!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 16:58 To: ProFox Email List profox@leafe.com Subject: RE: Including an SQL expression builder on a form
Yes, Calvin and also John Koziol were excellent coders but I just couldn't get on with Ken Levi's programming style - a little like his speaking style i.e. all enthusiasm and disconnected jumping from subject to subject. Steven Black certainly writes great neat structured code, which raises the discussion what makes a good developer... Maybe food for another thread!!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 15:55 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
Doug Hennig's code, in the Stonefield Tools, was something I needed to review in depth, mostly in the debugger, to chase down an obscure bug in a client's database. Excellent coding style, imo.
On Mon, Feb 22, 2016 at 11:59 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
I'll add Andy Kramek and Marcia's coding style into the good pot also!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 16:58 To: ProFox Email List profox@leafe.com Subject: RE: Including an SQL expression builder on a form
Yes, Calvin and also John Koziol were excellent coders but I just couldn't get on with Ken Levi's programming style - a little like his speaking style i.e. all enthusiasm and disconnected jumping from subject to subject. Steven Black certainly writes great neat structured code, which raises the discussion what makes a good developer... Maybe food for another thread!!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 15:55 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
Oops, I forgot to add Doug into the mix!!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 22 February 2016 17:03 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
Doug Hennig's code, in the Stonefield Tools, was something I needed to review in depth, mostly in the debugger, to chase down an obscure bug in a client's database. Excellent coding style, imo.
On Mon, Feb 22, 2016 at 11:59 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
I'll add Andy Kramek and Marcia's coding style into the good pot also!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 16:58 To: ProFox Email List profox@leafe.com Subject: RE: Including an SQL expression builder on a form
Yes, Calvin and also John Koziol were excellent coders but I just couldn't get on with Ken Levi's programming style - a little like his speaking style i.e. all enthusiasm and disconnected jumping from subject to subject. Steven Black certainly writes great neat structured code, which raises the discussion what makes a good developer... Maybe food for another thread!!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 15:55 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
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:profox-bounces@leafe.com] On Behalf Of AndyHC Sent: 22 February 2016 11:25 To: profox@leafe.com 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 srussell705@gmail.com wrote:
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.
-- 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]
On 22/02/2016 17:03, Dave Crozier wrote:
Oops, I forgot to add Doug into the mix!!
Dave
I thought as soon as you started listing names, you were digging a hole. Everyone not on the list is a bad coder ;-)
Donald Trump will be sooo pissed ;-)
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
;-)
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Peter Cushing Sent: 22 February 2016 17:07 To: profox@leafe.com Subject: Re: Including an SQL expression builder on a form
On 22/02/2016 17:03, Dave Crozier wrote:
Oops, I forgot to add Doug into the mix!!
Dave
I thought as soon as you started listing names, you were digging a hole. Everyone not on the list is a bad coder ;-)
Donald Trump will be sooo pissed ;-)
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
-
AndyHC -
Dave Crozier -
Joe Yoder -
Malcolm Greene -
Peter Cushing -
Stephen Russell -
Ted Roche