I am creating a remote view (with tehe view designer) and I need the group by clause. When I view the SQL code, it is okay. When I run the view, it is also okay.

BUT, when I add my view to the dataenviroment (through a framework) and I set the NoDataOnLoad to .T., VFP doesn't send the group by clause to the server (not even other filters I have set). It just sends my selected fields, plus 'where 1=0'...

When I set NoDataOnLoad to .F., everything is allright.

Why is that?
Is this a bug?

I'm using VFP 7.0 and MS SQL Server 2000.