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
Range missing in zTable?
Moderators: gto, cipto_kh, EgonHugeist
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.
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.
.
