Re: [NF][RANT] I need to stop playing 20 questions...

Yes, you may know what you really want (but not always) and really need (not nearly so often the case). You are the guy with the money, and you are the guy who makes the decisions, and none of this guarantees that you are not about to make a totally stupid decision, or one that is

RE: Problem with GROUP BY

-Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, February 22, 2016 2:08 PM To: ProFox Email List Subject: RE: Problem with GROUP BY At 13:06 2016-02-20, "jerry foote" wrote: >Thanks for all the feed back

Re: [NF][RANT] I need to stop playing 20 questions...

At 11:34 2016-02-22, Ted Roche wrote: On Mon, Feb 22, 2016 at 2:11 PM, Gene Wirchenko wrote: > > I have a new job which I hope will work out. Part of why I have it is > because of this failure in communication. It is quite the juggling act. Best of

RE: Problem with GROUP BY

At 13:06 2016-02-20, "jerry foote" wrote: Thanks for all the feed back on the group by clause. This what I ended up with SELECT service.manifest_n, service.bill_of_la, service.release_no, service.frm_acct, service.source,; service.source_id, sum(service.units) as totat

Re: [OT] Two DHCP servers on a network

At 12:22 2016-02-20, Paul Hill wrote: On 20 February 2016 at 16:20, Graham Brown wrote: > The Virgin Media router also has DHCP. My Virgin Media has an option for 'modem mode' or similar that switches off DHCP. You can find this in the admin

Re: [NF][RANT] I need to stop playing 20 questions...

On Mon, Feb 22, 2016 at 2:11 PM, Gene Wirchenko wrote: > > I have a new job which I hope will work out. Part of why I have it is > because of this failure in communication. It is quite the juggling act. > Best of luck in your new job! -- Ted Roche Ted Roche &

Re: [NF][RANT] I need to stop playing 20 questions...

At 12:35 2016-02-19, "Ken Kixmoeller (ProFox)" wrote: On Fri, Feb 19, 2016 at 9:04 AM, Ted Roche wrote: > Happy Friday, all, and permit me to vent a little steam... > The only quibble is that I wouldn't add the [NF] tag -- it is F and

Re: [NF][RANT] I need to stop playing 20 questions...

At 08:02 2016-02-19, Ken Dibble wrote: * Ted Roche wrote: The Original Poster (OP) fails to explain: - why they want to do this, - what their environment is (OS, #records, performance needed, etc.), - what they have tried as an alternative, - the bigger picture of how

RE: Visual FoxPro Lifetime Achievement Awards?

I have forwarded this to the committee that handles it. I am not sure when the next round of nominations is going to be opened. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -Original Message- From: ProfoxTech

RE: [NF][RANT] I need to stop playing 20 questions...

Hey - I liked that Dragons comment! Regards, Kurt Wendt Consultant Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, February 19, 2016 10:44 AM To: profoxt...@leafe.com Subject: Re:

RE: [NF][RANT] I need to stop playing 20 questions...

I've never seen STFW before, until you just mentioned it Peter. Of course, the milder term used by Ted is the LMGTFY.com!:-) Regards, Kurt Wendt Consultant Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

RE: [OT] Two DHCP servers on a network

You may well get a better response making this [NF] as opposed to [OT] Graham! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 17:21 To: ProFox Email List Subject: RE: [OT] Two DHCP servers on a

RE: [OT] Two DHCP servers on a network

Doh!!! read this as DNS not DHCP!! But the same thing goes as the DHCP is turned on for each DNS server but only one is in operation at any one time. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 17:18 To: ProFox

RE: [OT] Two DHCP servers on a network

We have 2 x DNS 2012 servers on the network DNS-A and DNS-B but the second one is only used in auto failover situations within the 3 clusters. Maybe you should take a look at clustering. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown

RE: Including an SQL expression builder on a form

;-) Dave -Original Message- From: ProFox [mailto:profox-boun...@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

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

RE: Including an SQL expression builder on a form

Oops, I forgot to add Doug into the mix!! Dave -Original Message- From: ProFox [mailto:profox-boun...@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

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 wrote: > I'll add Andy Kramek and

RE: Including an SQL expression builder on a form

I'll add Andy Kramek and Marcia's coding style into the good pot also! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 22 February 2016 16:58 To: ProFox Email List Subject: RE: Including an SQL expression builder

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

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

RE: Including an SQL expression builder on a form

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

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

Re: Including an SQL expression builder on a form

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