>Michael,
>
>Here's a shot in the dark, but Fox sometimes had problems with ;'s if there was no space between it and the end of the line it continued. This was fixed in VFP, so I doubt it is it but it only takes a second to try. Just insert a space before each ; so you have;
>
>SELECT Blah, Blah, Blah ;
> FROM Blah, Blah ;
> ...
WOW! That was a tough one! After whittling it down, turns out that my problem was in placing the
ORDER BY before the
GROUP BY statement! The order of these two didn't create a problem in VFP3.0, but choked VFP6 big time (I haven't tried it in VFP5)!
Looks like they plugged the hole.
I thought I'd post the problem - not that too many people would stumble on this particular problem, but perhaps just knowing that SQL Syntax has become stricter may help someone else out of a jam.
Thanks, Jim!
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site