Re: Invalid Group By

Author: Stephen Russell

Posted: 2014-01-09 at 08:46:03

On Sat, Jan 4, 2014 at 8:22 AM, jerry foote <jerryf@footegroup.com> wrote:

> Thank you Rafael that was what I what I was looking for.

>

> ---------------

>

Setting behavior to "fix" the problem is not going to work outside of VFP

data. Instead just follow the simple rule that everything in your select

list of fields that is not an aggregate needs to become your group by list.

Then as you work with other backends over time you are doing it correctly.

--

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

---

_______________________________________________

Post Messages to: ProFox@leafe.com

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/CAJidMYJnvtOptFwi=bGngXBgD3iFmqgJK+U5md_ax-2F5dfFUg@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.

©2014 Stephen Russell