Jump to content

Scriptmaster's ExecuteSQL and WebDirect


This topic is 2246 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

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)

 

Link to comment
Share on other sites

This topic is 2246 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.