Execute an internal FM Script via SQL Statement?

[Kevin MacHeffner]

Hi all,

Is it possible to include logic in a SQL statement to start an internal Filemaker script?

If there are posts on this topic already, please feel free to point me in that direction.

Thanks!

Kevin

[Wim Decorte]

Nope. SQL/ODBC is strictly for data transfers. You can use the FM activeX implentation on Windows to trigger a script from the outside. See the FM help file under 'activeX'. Nice set of examples.

[Kevin MacHeffner]

Thanks. The help files do show great examples! Now, do you (or anyone else) know if it's possible to use the ActiveX automation from an ASP page? I've tried a couple of my own attempts and it looks like the process is being started on the server but I have no idea how to get it to open the script once I'm connected.

Thanks!

Kevin