morninger

You need one placeholder per value, in the IN clause. If you have 4 values, your query should be SELECT... IN (?,?,?,?) If you don't know how many values you have to manage in advance, you need some coding for creating the placeholders and manage the arguments. A bit tricky, but it can be done.

Perfect: I sent the sample file and the screenshot to plugins@360works.com. Please let me know if you need anything else. Thanks,

Hello, Sarah the script doesn't paste correctly: all the numbers are pasted using the point as decimal separator, which in Italy is used to separate thousands. I tried to replace with a comma, so it becomes "1,41", hoping you don't do some parsing based on the point character, but I get another error (I already logged the bug). If you want, I can send you the sample file, so you can take a look at the script the way it's pasted on my system.

Perfect. I don't know if this can help you, but the data in our timestamp fields are returned like "03/12/2012 19:12:28" from debugger (this is 3rd of december, according to italian format), while (of course) querying this data at database level using ExecuteSQL() it returns the canonical "database format" "2012-12-03 19:12:28".

Hello, Sarah I sent the bug report using the tool when the issue happened, on nov. 29, but I didn't receive any feedback...

I set up a simple sync procedure from a local copy to a hosted copy (FileMaker Server was running on the same machine, during this test). Tried the same operation from an iPhone 4 running FileMaker Go and I got the same results. FileMaker Pro Advanced 12.0v3 and FileMaker Server 12.0v2, last version of MirroSync (log available). I managed to postpone the demo to the end of this week: any help would be appreciated.