April 23, 200124 yr I have a script that syncs two databases (a & by just importing and updating the new records. I have two questions. 1. How can I get the script to delete a record in database "A" if it does not exist in database "B". 2 How can I get the script to run every hour to update records. Thanks. j
April 23, 200124 yr Troi has a plugin called Activator that can run scripts in other files at given times. See his line of plugins at www.Troi.com
April 24, 200124 yr 1. Make a relation from "A" to "B" with a uniqe record id. In "A", create a formula that looks for related records: set the field to IsValid(:record_id). The result will be 1 for records existing also in "B" and 0 for records not existing in "B". Search for the 0 and delete them. Gerd
Create an account or sign in to comment