General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only