ScriptMaster and ExecuteSQL

[fabriceN]

Hi,

does anyone know if ScriptMaster would be able to communicate with FileMaker via the ExecuteSQL interface, as plug-ins such as myFMbutler DoScript or 24U Toolbox do ?

Thanks,

[shmert]

Hello Fabrice,

This isn't possible currently, ScriptMaster doesn't have a function for accessing FileMaker via SQL. One reason for this is to preserve compatibility with FileMaker 7, which didn't have this ability.

Out of curiosity, what sort of use had you envisioned for this?

[fabriceN]

Hello Sam, and thank you for your reply.

Actually, I'm only catching up with ScriptMaster (what an amazing product, by the way), and I'm just trying to figure out what the limits are, with no particuliar idea as to SQL, except that 1 plug-in is better than 2.

I'm surprised by your answer though. Are there really many people still using 'FileMaker 8 Beta version' nowadays ?. There is surely something that I don't understand about HOW ScriptMaster works, because the way I see it, ScriptMaster 'only' executes Groovy scripts, so my question could have been 'can Groovy talk to FM in SQL ?', and I don't think Groovy is different in FM7 or FM10.

So obviously, there is more to understand... as I said, I'm only catching up, but with much enthusiasm :

[shmert]

Yes, you could use groovy to talk to filemaker via a JDBC connection. You'd need to load a JDBC driver for FileMaker (try out https://woof.dev.java.net/) and connect to an instance of FM server to execute the query. There's no way to execute SQL directly on the client, however.