How to Track Open Datasets?

Mark A. Deal

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How to Track Open Datasets?

I am just learning to use the cached updates features of D3 C/S and am
wondering if anybody has any brilliant suggestions on how to keep track of
the currently open datasets that require updating. In particular, I have a
number of datamodules that open and close for modular purposes and I don't
really know of a good way to maintain a centralized list of open datasets so
that I can keep them in an array and pass them to TDatabase.ApplyUpdates.

Any suggestions will be sincerely appreciated!

Mark A. Deal
Document & Data Solutions, LLC

Robert Lov

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to Track Open Datasets?

Hmm, I don't have a good soultion to that problem. However you may
want to consider calling TQuery.ApplyUpdates when and where it makes
sense within your user interface. If there is nothing to update
it should not error out.

Robert Love

Quote

Mark A. Deal wrote:

> I am just learning to use the cached updates features of D3 C/S and am
> wondering if anybody has any brilliant suggestions on how to keep track of
> the currently open datasets that require updating. In particular, I have a
> number of datamodules that open and close for modular purposes and I don't
> really know of a good way to maintain a centralized list of open datasets so
> that I can keep them in an array and pass them to TDatabase.ApplyUpdates.

> Any suggestions will be sincerely appreciated!

> Mark A. Deal
> Document & Data Solutions, LLC

Jose Teixeira de Oliveira Junio

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to Track Open Datasets?

Hi,

To save my work in with cached updates, i use:

TTable.Post;
TTable.ApplyUpdates;
TDatabase.Commit;
TTable.CommitUpdates;

In order to keep track, try implementing something on the AfterChange
enevt for the table on your DataModule.

Txr

Quote

Mark A. Deal wrote:
> I am just learning to use the cached updates features of D3 C/S and am

> wondering if anybody has any brilliant suggestions on how to keep
> track of
> the currently open datasets that require updating. In particular, I
> have a
> number of datamodules that open and close for modular purposes and I
> don't
> really know of a good way to maintain a centralized list of open
> datasets so
> that I can keep them in an array and pass them to
> TDatabase.ApplyUpdates.

> Any suggestions will be sincerely appreciated!

> Mark A. Deal
> Document & Data Solutions, LLC

Other Threads

1. Track Mouse Clicks and Programs opened by User

2. Tracking open child forms in MDI apps

3. Keeping track of origins of local files opened through netscape

4. Indy keeping track of open windows

5. Borland is not back-tracking on Open Source

6. Tracking down AV error on Query open

7. Help: Overhead of keeping Datasets Open?

8. Open datasets & web

9. Open/Active DataSets

10. Execution speed - reading from open datasets