>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

Is this fixed in VFP 8 by the way?