What does the FetchRow property do?

The stable tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.
lsrzj
Fresh Boarder
Fresh Boarder
Posts: 19
Joined: 26.07.2013, 16:30

What does the FetchRow property do?

Postby lsrzj » 06.08.2013, 03:28

It's just a doubt about what this property is for. Does it stands for query result pagination? Like I have 1000 rows from a query, if I put FetchRow to 100 will it fetch 100 rows at a time as needed?

I couldn't find any Zeos documentation giving details on how does it work and what the components properties are for, is there any complete or extensive documentation out there?

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 11.08.2013, 11:40

lsrzj,

Like I have 1000 rows from a query, if I put FetchRow to 100 will it fetch 100 rows at a time as needed

I think you're right. But i didn't test it by my selves ever..

I couldn't find any Zeos documentation giving details on how does it work and what the components properties are for, is there any complete or extensive documentation out there?

A weak point, i know. Mark and me are developers. Don't expect we've the time to write documentaions too. Don't hessitate to start a wike. You can update some Wiki's from the Lazarus forum or write some by your selves and we'll attach it in our forum.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

lsrzj
Fresh Boarder
Fresh Boarder
Posts: 19
Joined: 26.07.2013, 16:30

Postby lsrzj » 12.08.2013, 22:53

EgonHugeist,

I made some tests and they apparently indicate that this property does exactly this. But I don't have a way to prove that this is true, because using ZSQLMonitor don't put any LIMIT on the select. Also, putting master detail relationship on the query, only generate SQL output text for the detail, and not for the master query that is being synced by the detail one.


Return to “ZeosLib 7.0 Stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest