| Subject | Re: [IBO] Limiting the potential maximum size of sets via where clauses |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-07-10T07:27:36Z |
At 19:23 09.07.2003 +0200, you wrote:
SELECT FIRST <number> SKIP <number>
syntax, so if you issue SELECT FIRST 10 you get the first ten rows, and
SELECT FIRST 10 SKIP 10 gets you the next ten. Though if you do something
like this, make sure your transactions are properly set up, so that the
second query have the same visible records as the first one (otherwise you
risk one record not showing or showing twice).
Set
>Can i control how many rows i want fetch from a query and then when myJust adding to Helens answer. Firebird do accept
>user push a button continue fetching next sets of rows with IBOQuery ?
SELECT FIRST <number> SKIP <number>
syntax, so if you issue SELECT FIRST 10 you get the first ten rows, and
SELECT FIRST 10 SKIP 10 gets you the next ten. Though if you do something
like this, make sure your transactions are properly set up, so that the
second query have the same visible records as the first one (otherwise you
risk one record not showing or showing twice).
Set