U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

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

Return to the default flat view

Create a new topic

Submit Reply

Re: SqlArray Limit and Offset [message #7358 is a reply to message #7347]

Sat, 23 December 2006 12:55

mirek is currently offline

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

fabio wrote on Sat, 23 December 2006 04:01

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 .....

Well, thinking about it even more...

Maybe we just stop at the fact that Oracle lacks support for these.

In fact, Oracle/U++ is may daily bread and I never really needed offset/limit. Somehow that is not how Oracle is used.

Mirek

Report message to a moderator

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Tue Jul 08 22:39:42 CEST 2025

Total time taken to generate the page: 0.03656 seconds