Page 1 of 1

Fetching Large table

Posted: 04.02.2008, 10:55
by sandeep_c24
I thought if I set the Filtered property of TZTable to true and opened it it would not fetch all the records in a table at once but would get them as needed. This doesn't seem to be the case. Is there a way to make TZTable to fetch records as and when needed?

Regards

Sandeep

Posted: 04.02.2008, 12:06
by mdaems
Bad option probably, but use a TZQuery as is documented everywhere on the forum?

Posted: 05.02.2008, 08:41
by sandeep_c24
Even if I set the Filtered property yo True in TZQuery all records are fetched and not fetched on demand as expected. I testing using Postgres 8.

Anything else I could try?

Regards

Sandeep

Posted: 05.02.2008, 12:16
by tam
Filter your data with the where clause of your query.