Re: SQL & Grouping Problem...

Ken - U Mac-Head, you really made me laugh on that one! And, actually - U kinda hit-the-nail-on-the-head with your reply. Its what I was thinking - and why when people say I gotta list all the fields - which are already listed at the beginning of the Select - it seems to make SQL look VERY Cumb

Re: SQL & Grouping Problem...

> > (You must list all the fields that do not contain an aggregate function > in the group by clause) > > > > The way you wrote it only works if your set enginebehavior setting is 70 > > > > The above is so you can make your sql statement compatible with SQL Server >--- > >Ama

Re: [OT] pretty funny

- Original Message - From: "Stephen Russell" To: "ProFox Email List" Sent: Wednesday, July 18, 2012 8:59 PM Subject: [OT] pretty funny > > > I saw it yesterday. Excellent. Based on "Me, Myself, and I" - short st

Re: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

On 7/18/2012 4:11 PM, Tracy Pearson wrote: > Mike, > > #IF .F. > LOCAL THIS as ObjectClass > #ENDIF > > Sometimes the syntax might be > #IF .F. > LOCAL THIS as ObjectClass OF WONTOP() > #ENDIF That did it...THANKS Saved this one in the "Kee

RE: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

I think you have to create the instance from the command prompt and attach it to a global variable, like _screen, then intellisense will kick in when you are in the programming window. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB

RE: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

MB Software Solutions, LLC wrote on 2012-07-18: > But that doesn't work when I'm writing/creating code and using THIS. > > For example, if in a method in my class I want to write > IF THIS.SystemName = "ABC" THEN > messagebox("Rock on, man!") > ENDIF > ...and I want Intellise

Re: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

But that doesn't work when I'm writing/creating code and using THIS. For example, if in a method in my class I want to write IF THIS.SystemName = "ABC" THEN messagebox("Rock on, man!") ENDIF ...and I want Intellisense to kick in right after I type "THIS." See what I mean? I want to

RE: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

LOCAL myvar AS [myclass.myobject] You have to have "set classlib to myclass" in scope. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, July 18, 2012 3:39 PM To: profoxt...@leafe.co

What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

VFP9SP2 I've got a PRG based class that I'm writing and I want Intellisense to kick in for "THIS." when I'm writing procedure code. I can't recall the trick. Was it with a #DEFINE or something? Remember -- this is not the instantiated object I'm talking about...rather, I'm writing the class

Re: SQL & Grouping Problem...

Like version 4? :-) On 18 July 2012 19:51, Fred Taylor wrote: > And what happens if you skip a version? > > Fred > > > On Wed, Jul 18, 2012 at 11:44 AM, Paul McNett wrote: > >> On 7/18/12 11:26 AM, Stephen Russell wrote: >> > Amazing that they added the switch to keep it working in a broken >> >

Re: SQL & Grouping Problem...

On 7/18/12 11:51 AM, Fred Taylor wrote: > And what happens if you skip a version? You pay an even harsher penalty for not keeping up. Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-fre

Re: SQL & Grouping Problem...

Set enginebehavior 70 Regards, Desmond On 18 July 2012 12:36, Kurt Wendt wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not >

Re: SQL & Grouping Problem...

And what happens if you skip a version? Fred On Wed, Jul 18, 2012 at 11:44 AM, Paul McNett wrote: > On 7/18/12 11:26 AM, Stephen Russell wrote: > > Amazing that they added the switch to keep it working in a broken > > fashion instead of forcing people to do it properly. > > I agree with the sw

Re: SQL & Grouping Problem...

On 7/18/12 11:26 AM, Stephen Russell wrote: > Amazing that they added the switch to keep it working in a broken > fashion instead of forcing people to do it properly. I agree with the switch during a transition period of about one version. Paul ___ Po

RE: SQL & Grouping Problem...

Thanks again to EVERYONE for your feedback. Yes, I ran into that SQL Behavior issue before, and was set straight on it here on the list. But, that was a while ago - and I forgot about it. So - thank you ALL for the reminders! -K- -Original Message- From: profoxtech-boun...@leafe.com [mail

Re: SQL & Grouping Problem...

On Wed, Jul 18, 2012 at 1:04 PM, Rafael Copquin wrote: > If you are using SET ENGINEBEHAVIOR 80 or 90 the group by clause should > have been written as follows: > > GROUP BY SHIPNO, pono,vendor,REFNO,REFDATE,Complete > > (You must list all the fields that do not contain an aggregate function in

Re: SQL & Grouping Problem...

On Wed, Jul 18, 2012 at 12:36 PM, Kurt Wendt wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not > working this time around. > >

Re: SQL & Grouping Problem...

If you are using SET ENGINEBEHAVIOR 80 or 90 the group by clause should have been written as follows: GROUP BY SHIPNO, pono,vendor,REFNO,REFDATE,Complete (You must list all the fields that do not contain an aggregate function in the group by clause) The way you wrote it only works if your set

RE: SQL & Grouping Problem...

OH Yes - That IS IT! Thanks Matt - its SO MUCH Appreciated! I had a similar problem about a year ago or more - and I posted it here. It was the same problem. For this particular instance - I'm still working on this screen(which I posted about here on the list a little while ago) that must be used

Re: SQL & Grouping Problem...

You are working with VFP9 ? Try to write SET ENGINEBEHAVIOR 70 before your query SQL in VFP9 is a lot more 'standard' than before and, now and normally, you must have all non aggregate fields in the group by clause ... hth The Foxil ___ Post Message

Re: SQL & Grouping Problem...

Kurt, the SQL you are using is considered invalid or at least ambiguous. According to ANSI SQL standards you need to include all fields that are not aggregated in the group by. VFP used to accept this invalid SQL and you can change a setting to allow it again, but you should really adjust yo

Re: SQL & Grouping Problem...

On 7/18/12 10:36 AM, Kurt Wendt wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not > working this time around. > > > > The ac

RE: SQL & Grouping Problem...

If you have enginebehavior 80 or 90, VFP will expect conformance to ANSI standard for grouping. You need to add aggregate functions to the non-grouped columns or add those columns to the group as Mr. Jarvis suggested. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:p

Re: SQL & Grouping Problem...

On Wed, Jul 18, 2012 at 10:36 AM, Kurt Wendt wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not > working this time around. >

SQL & Grouping Problem...

I'm getting this error - it claims that GROUP BY is Missing or Invalid. And, for the life of me - I don't see the problem. I've done Grouping before to Sum a particular column - so, just not sure why its not working this time around. The actual code is as follows: SELECT SHIPNO, PONO, Vendor,

Re: [NF] Network Question

On 07/17/2012 07:30 PM, Ted Roche wrote: > On Tue, Jul 17, 2012 at 5:18 PM, Jeff Johnson wrote: >> Ted: Ring Central is a VOIP service and each phone requires a separate >> external visible IP address. > So, each of these machines is separately connected to the Internet. > That's two points of ac

RE: [NF] Network Question

I would be more careful about friends :) Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Harvey Sent: 17 July 2012 22:51 To: profoxt...@leafe.com Subject: RE: [NF] Network Question The simple answer is "yes, it can be done."