Triggering script based on new MySQL record

[Dagel]

I'm running a FM back end with a relationship to an external MySQL table, in this case users_mysql. Is there a way to trigger a FM script whenever a new MySQL user record is created?

All I've been able to think of is to have a get( found count) field and then run this throughout the day:

If $$recordCount < $currentRecordCount and run the script if it's true.

Thanks for any thoughts...

[normanicus]

I'm not an expert in MySQL but, as you haven't yet received a reply, I'll do my best. There are triggers in MySQL. These are bits of code that are triggered when an event occurs. Your event would be new record creation. It says here:

http://dev.mysql.com/doc/refman/5.0/en/faqs-triggers.html

that triggers can now call stored procedures or external applications so this would be a way of achieving what you want to do. You could do it via a Python or Perl script as I'm pretty sure these languages have an interface to both mySQL and to Filemaker. Maybe there is a direct way to call an FM script from within mySQL?

[Dagel]

Good stuff. Thanks so much!

[Vaughan]

Why not use ESS?

[Dagel]

I am actually. You 're obviously considerably more knowledgeable on this topic than I, but how does that make any difference if FM is not seeing the record unless I run some kind of timed script?