any way to have the ExecuteSQL script step execute on the server?
I wrote a plugin function that calls the ExecuteSQL function internally. Works great on FMPro, and I want to see how well it works on FMS. For my particular application, I want the function to execute on the server. So I wrote a simple script that calls the function in a variable assignment step and made that a scheduled script. Script works ok, but when it hits the ExecuteSQL function call, server crashes.
Some documentation I found says that the ExecuteSQL script step isn't meant to be run in scheduled scripts. Does that also apply to plugins calling the ExecuteSQL function? Is there any other way to get this to run on the server? I read a suggestion somewhere that by setting the value of an unstored calc field to my function, I can force the function to be run on the server, even when the value is requested by an FMPro client. Is that accurate? I tried that as well but I wasn't able to even verify that the function was executing that way. But I'll keep pushing in that direction if it should work.