Jump to content

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


This topic is 3983 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 3983 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.