Detecting database change

MICROCIMM

Delphi Developer

Mon, 05 Nov 2001 03:00:00 GMT

Detecting database change

Hopefully a simple one.

I am looking for a way to know that a given table has been changed in any
way by any user (not just by the current app). I do not neet to know
specifically what they did, I just need to know that something was changed
(edited, deleted, added, etc).

Thank you in advance

Steve

Christoph Kindl

Delphi Developer

Tue, 06 Nov 2001 03:00:00 GMT

Re:Detecting database change

with mytable.refresh your table will be refreshed. if any changes are made
by another user, then this changes are displayed. if you are working in a
network then this i quite useful.
but if you want to know if changes are made then you have to use something
other which i don't know.

christoph kindle

Quote

>Hopefully a simple one.

>I am looking for a way to know that a given table has been changed in any
>way by any user (not just by the current app). I do not neet to know
>specifically what they did, I just need to know that something was changed
>(edited, deleted, added, etc).

>Thank you in advance

>Steve

Andreas Pawli

Delphi Developer

Thu, 08 Nov 2001 03:00:00 GMT

Re:Detecting database change

Quote

>MICROCIMM wrote:

>I am looking for a way to know that a given table has been changed in >any way by any user (not just by the current app). I do not neet to >know specifically what they did, I just need to know that something >was changed

Have a look at the OnDataChange event of the table's datasource.

__________
Andreas

Judd Reis

Delphi Developer

Wed, 14 Nov 2001 03:00:00 GMT

Re:Detecting database change

There is a TDataSet.modified property, though there can be problems using
this. It is, I believe, ReadOnly, so any modifications made by initialization
of a dbEdit field, etc. will also set this to true. It will also be true if a
user changes a field and then changes it back to the original value.

Judd Reiss

Quote

MICROCIMM wrote:
> Hopefully a simple one.

> I am looking for a way to know that a given table has been changed in any
> way by any user (not just by the current app). I do not neet to know
> specifically what they did, I just need to know that something was changed
> (edited, deleted, added, etc).

> Thank you in advance

> Steve

Other Threads

1. Detecting database changes by another client

2. Detecting changes to a database

3. How to change an oracle database to a paradox database

4. Detecting record changes

5. Q: How to detect row change in DBGrid?

6. how to Detect column width change

7. Detecting a record change in TDataSet components

8. Q: Detecting record-change

9. How to detect dbgrid row change

10. Detecting that your data has changed?