U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » SqlArray Limit and Offset

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: SqlArray Limit and Offset [message #7297 is a reply to message #7293]

Wed, 20 December 2006 21:00

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

fabio wrote on Wed, 20 December 2006 10:49

In oracle limit and offset not work......

Is very hard implement oracle dialect version of .Limit() and .Offset() why original query be bound to encapsulated in another select.
.......
SELECT * FROM (original query....) WHERE ROWNUM BETWEEN my_offset AND my_offset+my_limit;
.......

In SqlArray is possible to test Dialect and make another query (2 nested select) only for oracle dialect.

Any other idea ?

Actually, dialects are gone. U++ is now able to "compile" SqlExp for each rdbms (well, able in sense that core of technology is there, but not all variants are implemented).

Anyway, in this case, it is indeed a problem because Oracle lacks this clause.

Mirek

Report message to a moderator

[Message index]

		SqlArray Limit and Offset By: zsolt on Fri, 11 August 2006 01:03
		Re: SqlArray Limit and Offset By: mirek on Fri, 11 August 2006 08:35
		Re: SqlArray Limit and Offset By: mirek on Fri, 11 August 2006 09:05
		Re: SqlArray Limit and Offset By: zsolt on Fri, 11 August 2006 09:41
		Re: SqlArray Limit and Offset By: zsolt on Fri, 11 August 2006 09:50
		Re: SqlArray Limit and Offset By: rbmatt on Fri, 11 August 2006 18:36
		Re: SqlArray Limit and Offset By: mirek on Fri, 11 August 2006 18:44
		Re: SqlArray Limit and Offset By: mirek on Fri, 11 August 2006 23:47
		Re: SqlArray Limit and Offset By: zsolt on Tue, 22 August 2006 14:10
		Re: SqlArray Limit and Offset By: mirek on Tue, 22 August 2006 15:21
		Re: SqlArray Limit and Offset By: fabio on Wed, 20 December 2006 16:49
		Re: SqlArray Limit and Offset By: mirek on Wed, 20 December 2006 21:00
		Re: SqlArray Limit and Offset By: fabio on Thu, 21 December 2006 15:17
		Re: SqlArray Limit and Offset By: mirek on Thu, 21 December 2006 21:49
		Re: SqlArray Limit and Offset By: fabio on Sat, 23 December 2006 10:01
		Re: SqlArray Limit and Offset By: mirek on Sat, 23 December 2006 12:55
		Re: SqlArray Limit and Offset By: fabio on Wed, 27 December 2006 17:09
		Re: SqlArray Limit and Offset By: mirek on Sun, 31 December 2006 09:27

Previous Topic:	SqlArray::SetDistinct()
Next Topic:	ODBC ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jul 05 21:51:19 CEST 2025

Total time taken to generate the page: 0.03228 seconds