Create a Find Set to Delete Records in a script scheduled by FM Server

[Ewanmac]

I am relatively new to Filemaker so please help.

 

I have a Filmaker solution that imports data regularly from various SQL sources. At certain times I require to delete all imported data in the Filemaker solution and then re-import. The Filemaker solution is hosted on an FM Server and contains no forms, only tables (These tables are accessed via various other FM solutions). The import is handled via ODBC and is scheduled using the schedule function on the server.

All this works fine.

 

When I require to delete the imported data, I use the 'Delete All Records' function in the script proceeded with the 'Perform Find' function as follows:

 

Perform Find [Restore]

Delete All Records [No Dialog]

 

When I execute the script, I get the following message: 'This operation could not be completed because the target is not part of a related table.'

 

The correct table is selected in the Perform Find criteria but there are no forms (Layouts ) in the solution.

 

Has anyone got any ideas please.

 

Regards

[Wim Decorte]

There  has to be at least one layout per table in the solution and before the Perform Find you need to go to the correct layout for the table you want to work with.

In FileMaker table context is always set through the layouts.

[Rick Whitelaw]

To add to Wim's reply, a table can be "represented" by a blank layout if there is no requirement for any fields. In this case the layout does nothing but provide a context.