ExecuteSQL on server with external file

[csad]

Hello,

i run a scheduled script on ther FM Server 10. this sheduled script from File "APP_Engine.fp7" run ExecuteSQL("SELECT Field1 FROM Table1"). The result of the excecution ist "ERROR" !

Table1 exists as a Table occurence (TO) in APP_Engine und comes from an other external file "DAT_Engine.fp7".

what am I doing wrong?

 

NOTICE.: When i run the SELECT on an internal Table (in APP_Engine.fp7), it works.

 

thanks for your help!

 

 

[Opotoc]

Have you created a plugin for ExecuteSQL()?

To my knowledge you can only use ExecuteSQL() with ScriptMaster Advanced and you cannot invoke it via a Script Step.

You need to create a custom plugin.

[csad]

Yes, i created a custom plugin und use its ExecuteSQL().

When i run the SELECT-Statement on an internal Table (in APP_Engine.fp7), it works.

[Opotoc]

Are you sure the path to the external file is working on the server?

Before FileMaker had native Execute SQL I used the same technique and never had any  problems.

[csad]

the external file reference is working on a FM client with server hosted files. The reference is relative (file:DAT_Engine).

why is the file reference not working on the server?

[David Wikström]

Is the external file in the same folder on the server?

[csad]

No, is not the same folder. But i tyed with the network reference "fmnet:/192.168.10.10/DAT_Engine" instead of "file:DAT_Engine".  And i have the same problem.

[David Wikström]

I believe this isn't a ScriptMaster problem per se.

 

In older versions of FileMaker, you needed to include the folder name in the reference to external files that were in other folders on the same server, using something like file:../FolderName/FileName.fp7 in order for server-side scripts to work.

It was impossible to run server-side scripts referencing table occurrences from files hosted on other servers.

 

In FileMaker 12, both now work fine (thanks FileMaker Inc!).

[csad]

Thank you for your answer! This knowledge help me!