Board index » delphi » Filtering on a TTable with CachedUpdate

Peter Kahle

Delphi Developer
Mon, 28 May 2001 03:00:00 GMT

Filtering on a TTable with CachedUpdate

Using Delphi 3 and paradox tables, is it possible to filter on a TTable
with CachedUpdate active without committing any changes to the database
that may be waiting? Or do I have to run a separate query instead?
Thanks,
Peter Kahle
Diamond Data Systems
 
Michael Glat

Delphi Developer
Mon, 28 May 2001 03:00:00 GMT

Re:Filtering on a TTable with CachedUpdate


All that a filter does is restrict the viewing of the dataset to the
parameters that you give it.  It does nothing whatsoever to the database.
Applying one will not affect the changes to other records you may have made
before applying those changes.

--
Michael Glatz
mgl...@caiso.com

Quote
Peter Kahle wrote in message <366FE63E.6CFE4...@diamonddata.com>...
>Using Delphi 3 and paradox tables, is it possible to filter on a TTable
>with CachedUpdate active without committing any changes to the database
>that may be waiting? Or do I have to run a separate query instead?
>Thanks,
>Peter Kahle
>Diamond Data Systems

Peter Kahl

Delphi Developer
Mon, 28 May 2001 03:00:00 GMT

Re:Filtering on a TTable with CachedUpdate


OK, I guess I wasn't clear enough. The problem amounts to the RecordCount not
updating when I set a filter. It works fine if CachedUpdates is false, but it
doesn't work if CachedUpdates is true.
Peter
Quote
Michael Glatz wrote:
> All that a filter does is restrict the viewing of the dataset to the
> parameters that you give it.  It does nothing whatsoever to the database.
> Applying one will not affect the changes to other records you may have made
> before applying those changes.

> --
> Michael Glatz
> mgl...@caiso.com
> Peter Kahle wrote in message <366FE63E.6CFE4...@diamonddata.com>...
> >Using Delphi 3 and paradox tables, is it possible to filter on a TTable
> >with CachedUpdate active without committing any changes to the database
> >that may be waiting? Or do I have to run a separate query instead?
> >Thanks,
> >Peter Kahle
> >Diamond Data Systems

Other Threads

1. DELPHI ERRORS - TTable Filter, CachedUpdate and RecordCount.

2. Filter Problems - Does The Filter Property Required CachedUpdates True

3. TTable.filter - How to set a partial filter

4. Using CachedUpdates in TTable component

5. Identity, filters, MasterDetail and CachedUpdates, Please Help me

6. TDatabase's Transaction VS TTable's CachedUpdates

7. Recordcount, Filters, and CachedUpdate

8. CachedUpdates and filters

9. CachedUpdates and Filters

10. how to filter date in TTable