Page 1 of 1

Show all records (7x.xxx) - ORACLE

Posted: 25.01.2010, 14:01
by h.o.o.k
Hello,
I am from Czech Republic so excuse my English. I am programing database application for ORACLE with ZEOS components. And i want open Query with 9x.xxx record, but showing is very slowly. Can you help me please??? How showing all record fast or how fetch first 1000 record to DBgrid and on scrolling next records etc.

Thank you very much.

Posted: 26.01.2010, 00:05
by mdaems
What version of zeoslib are you using? With Zeos 6.6 you could try setting ZQuery.FetchRow to a value different from zero. But most depends on the way the DBGrid fetches the data from the ZQuery. If it just fills all data until end-of-resultset this won't help us.

Mark

THAN YOU VERY MUCH!!!

Posted: 26.01.2010, 07:39
by h.o.o.k
mdaems wrote:What version of zeoslib are you using? With Zeos 6.6 you could try setting ZQuery.FetchRow to a value different from zero. But most depends on the way the DBGrid fetches the data from the ZQuery. If it just fills all data until end-of-resultset this won't help us.

Mark
I had version of Zeos 6.5 . :0)))))
This is exactly it what i needed!!!!!!!!!!!! I lost 3 days because of this problem and i writed on 10 forums! You are the BEST! :0))) THANK YOU VERY VERY MUCH