Zeoslib Portal

I'm using Zeosdbo 6.5.1 alpha and a ZTable. I want to see only a number of records in the result set, but cannot find any property for that in the ZTable component. When using it on a 245.000 records table of which I only want to see the first 50, this is slooooww..

What I'm looking for: Select * from table LIMIT 0,50

Thanks for any help.

Regards,
Teo

Hi!
Never use a ZTable (any TTable) for such a big table. Use a ZQuery with the SQL you mentioned inside. In fact, always try to avoid TTable.
Regards,
Rüdiger

Hello Rüdiger,

Thanks for replying. I see remarks about avoiding TTable a lot, I know why but TTable kind of components were designed to do table editing.

Anyway.. You are right about the amount of records, that is why I wanted to get the first 50 or so. The ZTable component was very suitable for me because, in the architecture that I knew allowed me to show records in a dbGrid and edit them. (I'm working on a database management frontend kind of like mysql-front and want a plain view of the database content).

Unlike what I expected, a ZQuery needed some figuring out, but to my supprise is able to be used for data editing. So.. I replaced the ZTable with a ZQuery and all works fine.

Hi pol,

please also take a look into our Knowledge Base articles ... .

Hi Michael,

Thanks for your remark, but what exactly do you mean?

This ...