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 #7293 is a reply to message #4791]

Wed, 20 December 2006 16:49

fabio
Messages: 9
Registered: November 2006

Promising Member

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 ?

Fabio

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: Mon Jul 07 10:04:03 CEST 2025

Total time taken to generate the page: 0.03798 seconds