filemaker pro script examples to clear field in all records

We never know in advance what time we will be generating the report for. Geneating the stock report this way originally took around 40 minutes, 35 minutes of which was performing find in the unstored calc field.

We have a pretty generic inventory data model: we have a table of goods and a table of transactions. This looked like an easy request a few months ago. We were supposed to implement report of stock inventory at a specified time. We had hundreds of items on stock and thousands of items historically in our system. Let me show you what and how Petr actually optimized. After further examination I could confirm that it really does what it is supposed to do. But the script was returning correct results. My first thought was there must be something wrong. It took less than 2 minutes to run (over network). When I tried his optimized script on live data I was honestly surprised. The script recently started taking over 8 hours to run and reaching the expiration limit we have set for it. Last week I assigned Petr, our internal system developer, the task to optimize one server-side script.

Sometimes, not often, I accidentally achieve results that look too marvelous to be real.

Filemaker pro script examples to clear field in all records