fetchrow

[sfxcc]

Im using postgres and a zquery select * from items and using fetchrow = 10 but it still loads all query rows on the open. I only want 10 rows on start up and the rest as it is needed ...


How i fetch only 10 by 10 rows ?

Any effective answer ?

Is it working ,

[Sergiomaster]

Hello

FetchRow works ,i mean : i test it with Firebird and have the effect i hope. i wrote this "expérience" in a tutorial still in progress you can find herehttp://serge-girard.developpez.com/tuto ... p/ZeosDBO/ , hopping the tutorial is accessible )

if you want to only have the 10 first rows then use limit
i.e.

Code: Select all

select *
from scores
order by score desc
limit 10

[EgonHugeist]

It works for all plains. But this value only indicates count of row which are fetched from query.
It's no Limit/Offset sql change if you expect this.