forgive the test....please no flames!!!

From: David Pettit <cismail4.dpetti01_at_eds.com>
Date: 1996/09/24
Message-ID: <32483C3F.35B5_at_eds.com>#1/1


Carlos Augusto Leite Netto wrote:
>
> Vladimir Stavitsky wrote:
> >
> > I am afraid you have no choice other than put the number of records
> > already read into either hidden field in html form or in a DB record
> > which is unique for this user. When he comes again - just fetch
> > the records after the last one he read already.
> >
> > Hope this helps
>
> That's a good idea for general situations. If you're creating a general
> template, it's Ok. But if you're writing a program by hand and your table
> as a primary key based on a unique column, you can:
>
> select *
> from table
> where primary_key > :last_retrieved_pk and
> order by primary_key
>
> fetch how many rows you want (if you're creating a table browsing for
> HTML, for example) and register in :last_retrieved_pk the pk of the
> last rows fetched.
>
> It's not so generic, but's faster. If you primary_key is based on two
> or more fields, it's not so easy to take advantage of the pk's index
> to speed up the solution.
>
> Regards,
> --
> Name: Carlos Netto e-mail: cnetto_at_softdes.com.br
> Software Design Informatica Oracle System Integrator
> Oracle BAP member. Softex/2000 member. Campinas, Sao Paulo, Brazil
Please no flames!!! Please forgive this test. We are experiencing some network problems and I need to see if I could successfully post.

thank you
xxx
x
x
x
x
x
x
x
x

x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x
x Received on Tue Sep 24 1996 - 00:00:00 CEST

Original text of this message