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 #7347 is a reply to message #7318]

Sat, 23 December 2006 10:01

fabio
Messages: 9
Registered: November 2006

Promising Member

I am sorry for delay.....

Limit(offset,limit) is for actual (complete) query, and work only if used at end of query.

Why store for future use?

I think not possble implement multi-level "limit" in oracle.
This Oracle eccentric method require 2 extra query with extra column (rownum as row_num1...) with unique name. It is a hard work.

I can store not directly in "text" of SqlSelect class, but in new two string like "pre_text" and "post_text" (as in my first only-thinked version of Limit() method), but it also require an adjustment of SqlSelect class.

..... i am lazy .....

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: Sat Jul 05 23:01:40 CEST 2025

Total time taken to generate the page: 0.03645 seconds