FX PHP web users blocking each other's requests to FM

[cjr.at.work]

Hi to all,

We have a multi-user web application that uses FX PHP to update and grab data from FileMaker 11 Advanced Server. We're also using a robot script in FileMaker 11 Pro Advanced that pulls data from related tables for processing. The problem is that whenever there are several users or user requests to update a field on a table record the Filemaker Pro robot gets suspended with a popup message saying that a certain user is currently modifying a record. The robot script can't continue with its job while this popup is not closed so work also stops. Is there some way to prevent this popup from happening?

Please help.

Thanks for reading. :)

[bcooney]

Regardless of the methods that update data, you must deal with record lock via robust scripting. Use the Open Record script step in your robot script. If the Open Record isn't successful, then loop until it is (limit to a counter) or retry after a delay. Look into Transactional Scripting (see Todd Geist's blog).

btw: why a robot and not a server script?

[webko]

Or indeed, why a script? Why not do it all in the php?