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 #7408 is a reply to message #7358]

Wed, 27 December 2006 17:09

fabio
Messages: 9
Registered: November 2006

Promising Member

You can implement "limit and offset" at fetch level.
Many objects (Java, VB...) fetch and discard rows, simulating (one-way) limit and offset.....

In oracle 10g (and 9) is present a new version of OCIStmtFetch for make a clean limit solution:

 OCIStmtFetch2(stmthp, errhp, 1, OCI_FETCH_RELATIVE, fetchOffset, OCI_DEFAULT);

This fetches a row from the (scrollable) result set.

But, this oci function, and scrollable cursor feacture, is not present in oci8.

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: Sun Jun 09 01:24:44 CEST 2024

Total time taken to generate the page: 0.03233 seconds