SET ROWCOUNT X and the session will only select / delete / insert that many rows before stopping.
Hence, it should be feasible to code it easily
SET ROWCOUNT 0 disables the limit.
Terence Kwan wrote:
Hi all,
Does Torque support setLimit for Criteria with Sybase? It seems that although DBSybase.getLimitStyle() returns LIMIT_STYLE_SYBASE, BasePeer does not handle LIMIT_STYLE_SYBASE. The specific bit of code has been commented out in BasePeer. Thus if a Criteria.setLimit() is used, an exception will be thrown with this message: Incorrect syntax near 'LIMIT'.
I am using Sybase ASE 11.9.2 with the com.sybase.jdbc2.jdbc.SybDriver driver from jConnect5.5.
Any information will be most appreciated.
Thanks,
Terence
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
