May 26, 201114 yr Hello. I'm working with Filemaker 11. I have a found set of about 1000 records. I need to replace the data in one field (date)-- with a different date. I have tried the replace field contents script step. I have tried a loop script with variables. They work. But, it is slow with this number of records. It is taking several minutes to do this. I'm hoping there is a faster way to accomplish this. Thank you for any help.
May 26, 201114 yr There are ways to optimize a loop, and Replace is not multi-user friendly, so you're probably best not using it. When you loop, be on a form view with no unstored calc fields and Freeze Window before you start the loop. You can open a new window (offscreen perhaps), and close at the end. On another note, why are you replacing a date? Perhaps what you need is a child table with a new record?
Create an account or sign in to comment