Fetching Large table

sandeep_c24 · Post by **sandeep_c24** » 04.02.2008, 10:55

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

Post by **mdaems** » 04.02.2008, 12:06

Bad option probably, but use a TZQuery as is documented everywhere on the forum?

sandeep_c24 · Post by **sandeep_c24** » 05.02.2008, 08:41

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

tam · Post by **tam** » 05.02.2008, 12:16

Filter your data with the where clause of your query.