I want to be able to issue a SELECT statement, and:
(a) be able to cancel it at anytime
(b) set the fetch limit on the SELECT
Now, (a) makes me want to use OSqlStmt, and that works fine, as far a canceling goes. The problem is, OSqlStmt doesn't seem to support the concept of "fetch limit". It always seems to return the first row only, which makes sense considering it should only be used for DML.
Of course, (a) rules out ODynaset - there's no way to cancel them once they've started.