What is the best way (or the easy way) to browse (paging) a large table or
query result in the web ?

1) For every page called, execute the query and use moveby to provide a
paging effect ?

2) * ALWAYS * use the clause INTO to generate a temporary table and then
browse the pages using this temporary page ?

I am starting to develop an application and the web users must browse some
large tables and therefore, until now I don´t realise what is the best way
to do this.

Any comments will be welcome

Eduardo

Eduardo,

<<1) For every page called, execute the query and use moveby to provide a
paging effect ? >>

If you can generate a live query result, then this would be practical.  If
you can only generate a canned result set, then it probably won't be
practical.  If you're just using tables, then using MoveBy is the way to go.

<< 2) * ALWAYS * use the clause INTO to generate a temporary table and then
browse the pages using this temporary page ? >>

You can do this provided that you name the table something that can be
subsequently associated with the same user session via the web server.  You
will also need a method for cleaning up "stray" temporary tables that are
left around.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Thanks a lot. It was what I suspect.

Eduardo