Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Delphi Capture table changes

Posted on 2012-03-27
5
Medium Priority
?
324 Views
Last Modified: 2012-05-18
I have application written in Delphi 6. The application works with Local Access table. I need to know Immediately when this table has a new record (the record is being added from different application). Right now I am working with 3 seconds timer that count the records. Is there any other way to do it without this timer ?

Thanks & regards.
0
Comment
Question by:oferlll
  • 3
5 Comments
 
LVL 38

Accepted Solution

by:
Geert Gruwez earned 2000 total points
ID: 37771123
no, you are using the best approach
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 37771139
for short, you are limited by the database you are using

>> with oracle, you can register to get events immediately upon change
DBMS_ALERT sample:
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_alert.htm#CHDHACEG

access does not have this capability
0
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 2000 total points
ID: 37771147
but,
i would add a DATE/TIME Modified column

counting records will not show you the latest record modified

SELECT MAX(DT_MODIFIED) FROM TABLE

gives you the latest change time > store this and run again to check any changes
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question