Under ASA9 as far as I know, a sain paging technic could be
already achieved through the use of SELECT TOP n START AT p
[col]+ or window functions..

Unfortunately ASA7 lacks to this feature, and I can't figure
out any other way to handle it properly !

Any Indications on how to go about it ?

Thanks,

Let me guess ! I'm so fucked up ?

As ASA 7 does not support the START AT clause, I guess you basically
have to "number" your resultset and then use a WHERE clause to filter
the fitting numbers per page.

There's the number() function is ASA7 that might be useful; however, as
to ASA8 docs, number() should only be used in SELECT lists (and not in
WHERE clauses) as it might lead to inpredicable results, and obviously a
paging would need the numbers in the WHERE clause.

Therefore I'm not sure if the following would work in ASA 7:

select rowNo, col1, col2, .., colN
from
(select number(*) as rowNo, col1, col2, .., colN
from MyTable
order by col1) S
where rowNo between <p> and <p + n>
order by rowNo;

Note, that in order to filter the numbered rows, the number() function
must be used in a derived table (you have to number *before* the
filtering is done).


Other approaches to number rows, when no OLAP or START AT support is
available, include to join a result set with itself and by that counting
the results.

Some examples for MS SQL 2000 can be found here and should work with
ASA7, too:
"How to dynamically number rows in a SELECT Transact-SQL statement"
http://support.microsoft.com/default...b;en-us;186133

HTH
Volker





ZeroCool wrote:

October 12 was a holiday for all the SQL Anywhere engineers, and most
folks in the USA and Canada, and this is a volunteer forum...

So please be impatient, and PLEASE KEEP THE PROFANITY TO YOURSELF.

Breck

On 13 Oct 2009 01:25:02 -0700, ZeroCool wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Breck Carter [TeamSybase] wrote:
I'm sure that will make its way into "Breck's Famous Quotes"

Volker

Yeah, I meant to change the imperious "don't be impatient" into the
kindler gentler "please be patient", got the dyslexic version




On 13 Oct 2009 07:41:35 -0700, Volker Barth
<No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com