RE: [Crossdb-developers] setLimix(x,y)-Support

[<tr...@th...>]

setLimit() is not supported for the exact reasons you specified (not every db supports it).  We started working on the idea of different levels of features that a database supports so you could have Level1SelectQuery that would add extra features, and keep going up, but hte problem is that some database may support limits, but not unions and another may support unions but not limits, so you can't level it.  

We could have all these features in the base SelectQuery interface and throw UnssupportedException or something, but then you lose the database independence.

I'd be open to any suggestions you may have on this.  

Travis

---- Original Message ----
From: Georg Sendt <510...@t-...>
Sent: 2003-01-14
To: CrossDB Mailing <cro...@li...>
Subject: [Crossdb-developers] setLimix(x,y)-Support

It may be already discussed, but are there any reasons why there is no
setLimit(x,y)-Support?

I know it is possible for some databases (mySQL, PostgreSQL) directly
and there are some workarounds for mssql and oracle available.

--Georg 




-------------------------------------------------------
This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your  SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
Crossdb-developers mailing list
Cro...@li...
https://lists.sourceforge.net/lists/listinfo/crossdb-developers