>The problem also exists with parameterized queries. For example,
>
>nKeyField = 1
>SELECT * FROM TESTFILE WHERE KEYFIELD = ?nKeyField
>* This works becuase nKeyField is scoped during this statment.

As you said... it depends on how Rushmore optomizes the query to create the result set... a result set you shouldn't use GO on.

If you want to be sure to use go, and want a valid reccount, be sure to use the NOFILTER keyword on the select... as I think you said in a previous message.

Remember, also, a View is just a nicley dressed SQL statement.

BOb