The new GROUP BY requirements (an attempt to make VFP SQL more similar to MS SQL Server) really creates problems without the related MS SQL commands like WITH ROLLUP and WITH CUBE. I sure hope these functions are added in the next VFP... or maybe that VFP's ideas about GROUP BY are rolled into SQL Server (fat chance, eh)?
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site