>>I beleive, when you use Requery() command on your view to get real data, correct SQL statement will be sent to SQL Server.
>
>Yes, but the problem is that SQL server generates an error message (field is not valid in the select list, because it is not contained in blablabla :)), as soon as I want to open the table (without data), because the 'optimized' select statement is being send to the server.
>
>I believe it is bad optimizing :p
Understand now. I suspect you have something like aggregate functions inside of the fields list, am I right? :-)
You can simulate NODATA by self manually using view parameters. Specify parameter values initially by such way that you know for sure that query would never return any record. Then do requery with another parameter that return you required records.
>
>Is this fixed in VFP 8 by the way?
I do not know. To test this, I need to have your query from your view. Can you send it?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.