Scriptmaster's ExecuteSQL and WebDirect

[davidsilverthornsoftware]

Does anyone know if Scritpmaster's ExecuteSQL is limited in WebDirect?

I renamed the function to SQL on my end, to avoid confusion with Filemaker's native ExecuteSQL function. When attempting run a script using the SQL and it's INSERT INTO feature, Pro clients will be successful, but not Webdirect clients. I notice that WebDirect returns ERROR. I'm curious if this is limitation or quirk of some sort.

We're running on Filemaker Server 16 and Scriptmaster 5.09.

[ryan360Works]

Hi David,

       The modules that are included in the ScriptMaster are really just for example purposes and may not work in every use case/environment. With that being said, I am curious as to what the error actually is. Whenever you receive an "ERROR" from one of our plugins, you can use the LastError function to get a more detailed description of the error, in this case SMLastError. Set up an if conditional in your script that checks for ERROR as the result of the ExecuteSQL function and then sets a field to SMLastError if ERROR is returned.  Once you have the actual error, post it here.

 

[davidsilverthornsoftware]

The error appears to be File Missing (Error 100). Is there a need to specify the specific file from the groovy function? I don't see such a reference from the example file.

SEVERE: PluginFunction com.prosc.beanshell.CompiledFunction@4195cac5 got an error with converted args [INSERT INTO Logging ( priority, category, description, parent , layout, script )  VALUES ('Normal','Field Modification','Case::contact_role: ERROR',12063651366639000000012200002066265427320,'Cases: List','Cases: Find Open')]
com.prosc.fmkit.FmCalculationException: 100
at com.prosc.fmkit.PluginContext.evaluateExpression(PluginContext.java:178)
at com.prosc.fmkit.PluginContext.executeSql(PluginContext.java:199)
at com.prosc.beanshell.FMPro.executeSql(FMPro.java:192)
at com.prosc.beanshell.FMPro.executeSql(FMPro.java:187)
at com.prosc.beanshell.FMPro$executeSql.call(Unknown Source)
at scriptmaster_Module_MTk3MDE0MTkzNwXX.run(scriptmaster_Module_MTk3MDE0MTkzNwXX.script:1)
at com.prosc.beanshell.GroovyFunction._invoke(GroovyFunction.java:163)
at com.prosc.beanshell.GroovyFunction.invoke(GroovyFunction.java:141)
at com.prosc.beanshell.CompiledFunction.invoke(CompiledFunction.java:85)
at com.prosc.fmkit.Plugin.invokeFunction(Plugin.java:384)
at com.prosc.fmkit.RegisterablePlugin.invokeFunction(RegisterablePlugin.java:177)
at com.prosc.fmkit.Plugin.invokeFunctionNoErrors(Plugin.java:364)
at com.prosc.fmkit.PluginBridge2$1.call(PluginBridge2.java:860)
at com.prosc.fmkit.PluginBridge2$1.call(PluginBridge2.java:848)
at com.prosc.fmkit.PluginBridge2.doFunction(PluginBridge2.java:880)
at com.prosc.fmkit.PipeChild.lambda$handleMessage$11(PipeChild.java:319)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)