Page 1 of 1

What does the FetchRow property do?

Posted: 06.08.2013, 03:28
by lsrzj
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?

Posted: 11.08.2013, 11:40
by EgonHugeist
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.

Posted: 12.08.2013, 22:53
by lsrzj
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.