Re: Call for an API standard for SQL statements

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 25 Oct 2004 09:46:23 -0700
Message-ID: <Vjafd.37$6e.54_at_news.oracle.com>


"Fredrik Bertilsson" <fredrik_bertilsson_at_passagen.se> wrote in message news:31f7e57d.0410232150.72331ee1_at_posting.google.com...
> That is not what i meant. The programmer only needs to give the
> original query, like "select * from employee order by employee_id".
> The framework will add the extra where condition "emplyee_id > ?" for
> paging. Paging where the sort criteria is built up from multiple
> columns, will give you very ugly and difficult SQL statements. But a
> framework can build them automatically.

Suppose you have list of employees like this

emplyee_id name
---------- -----------
0000000001 John Doe

0000000010 ...
0000000010 ...
0000000010 ...
0000000010 ...
0000000010 ...
Received on Mon Oct 25 2004 - 18:46:23 CEST

Original text of this message