Scriptmaster 4.205 executeSQL Filemaker 13

[Awehl]

I use for my Solution the latest Version 4.205, on Windows 7 with FM13 Advanced. I intensive use the executeSql function (Selects, Updates and Inserts), but with FM13 Advanced the SQL-Querys results with an error: "com.prosc.fmkit.FmCalculationException: 3". With Filemaker 12 Advanced the same Query runs faultless.

What can be the problem?

[Claus Lavendt]

I have seen the same issue today and thought it must be that the generated plugin is 32bit and windows7 is 64bit (on the machine at my client today)

However, I was not able to install the 64bit version successfully.

In FM13, FMI has removed the old sql API calls, which was used in SM in older versions.

However, the error code 3 indicates that the windows version still uses the old API calls for executesql…..

[Claus Lavendt]

ohh…. just talked with 360 and the issue with executesql function in the plugin on windows, is actually a known bug, which they are working on.

Hopefully a new version of SM will be released soon, that takes care of this issue.

 

Regarding the 64bit, well, the 64bit version of the plugin is for using on server only…...