At 08:14 1-1-2004 -0500, D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
What I am searching for is when I retrieved Row 2, I want to go to Row 3,
and find an efficient way to do this.
What I tried is this
First go to Row 2, doesn't matter how, but I found the RowID belonging to
Row 2
I want to do (what is called in Delphi way of data-access) a Next, I do this
"select rowid,..... from testtableint where rowid>2 limit 1"
I then store the RowId in a variable, and use it for the next time Next.
It works, but I wonder, is this the most efficient (quick) way to do this.
Yes
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Is it really much quicker than:
select min(rowid) from testtableint having rowid>2;
and is there a way to show the time a query takes to execute ?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
