>Using SFQuery and SDT 6 with VFP 9, anytime I try to click the Values button (while building a query), I get an error "Having Clause is invalid"....
>
>Since I haven't used SFQuery (or SDT) in quite awhile (last used it with VFP 6 with no problems), I was curious if there is something I should know about using it with VFP 9?
>
>I'm working on an older app and decided to make all the changes in VFP 9 (seems like a good idea at the time)... lol
>
>Any assistance is appreciated,


Does your SQL command have a GROUP BY clause? HAVING requires a GROUP BY.