[Tutor] Tracking variable changes in a different application

[Emile van Sebille]

On 9/1/2009 12:51 PM Kristina Ambert said...
> Hi again,
> 
> The question might be a tad confusing, but what I want to ask is, if 
> it's possible to track if and when a variable in an application has 
> changed, and then grab the new content of that variable?

So, you want to be notified when a field in an external database 
changes.  Databases commonly do this with triggers.  Generally, I've not 
had access to the external databases, and so have had to detect changes 
in other ways.  Depending on what I have access to I'll do one of 
several different things ranging from date and time stamp checking (to 
know when it changed), through ODBC connections for database access (so 
data is always current), to overnight data export and syncing (because 
it's good enough).  If you describe your environment and requirements 
further specific solutions may be offered.

Emile