posted 19 years ago
no.
A fetchsize is used for caching more or less results.
Of course, if the database supports 'fetchsize', there might not be much use in a fetchsize < 2.
But since it isn't build for counting results, I wouldn't like to stick on it.
At least I would read the documentation of fetchsize very carefully - Perhaps the fetchsize is allways '200', even if there is only one result?
'select count (*) ...' would be the ordinary way.
Scrolling forward and back would be a workaround too, but as far as I know, not every vendor supports scrollable resultsets, and maybee it depends on query-details too.
You could get dependent on a specific database that way.