0 Replies Latest reply on May 21, 2003 8:55 PM by 385190

    OSqlStmt cannot return all rows?

    385190
      I'm wondering if there's any way to do this.

      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.

      So, is there some trick to doing this? Thanks.