m0nkey

Hi, Thanks for your replies. I have tried adding a pause and creating a linking script but this has not made a difference unfortunately. Literally the only way that I can get Filemaker to perform the import scripts in succession is closing the fm database in-between each run. Based on this, I think comment's suggestion of the problem being ODBC source side to be the case, however I have no idea on how I'd go about resolving this. The only operation being performed is a Filemaker import based on a SQL query, there's no data being committed to the odbc source, etc. Other than asking the user to run one script, close FM database and then re-open to run the 2nd script (this process works), any suggestions on what I could try? Thanks again for your time.

Hi everyone, On Filemaker Pro 13 I'm trying to run a script that performs two Import Record actions (both from an ODBC data source). The script is performing the imports into the same fm database. The script gives a completion message with no errors, however only the first import works. The second import does not process any records. When I run the imports separately, only one at a time, either scripted or manually (File>Import Records>ODBC...) they both process records successfully. My problem only seems to occur when performing multiple scripted imports. Does anyone know if there's a script action I have to perform in-between the imports? Any advice would be greatly appreciated. Many thanks in advance for your time, Richie.

Hey Reed, You are an absolute star, that works perfectly. Thank you ever so much, you have saved me hours and hours of frustration Thank you, thank you, thank you!

Hi, I have recently started using the ExecuteSQL functionality in Filemaker Pro. I can successfully run SQL in FM via an ODBC connection to an Oracle database. Please can anyone tell me how I can execute a stored procedure held in the Oracle database? Thanks in advance Rich.

Hey all, wondering if you can help a FM newbie. I'd like to send a specific email to a search group. Once I have the records I want I select "Send Mail" and specify a field name that contains the email address that I want to send the email to, etc. FM then crashes with a WMS Idle Application Error. Any ideas would be greatly appreciated. Thanks.