Hi!

Why you might need group by, order by and WHERE, when there are NO DATA? :-) VFP just optimizes query for you to get emopty record set by as quick as possible way.

I beleive, when you use Requery() command on your view to get real data, correct SQL statement will be sent to SQL Server.

HTH.

>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.