How to handle record in use via PHP API...???

[angelleye]

I'm working with eBay's notification system that posts data to my script when auctions end. My script takes that data and updates our FileMaker via the PHP API so we get updates in real-time.

The problem is if there's a user in the auction record at the time the auction ends I end up with error from FM that it can't update because of that.

I tried adding a script into FM with nothing but a commit record step and then I added that to my PHP script at the top using a perform script step but that doesn't seem to be working either.

Any information on how I might get around this problem would be greatly appreciated. Thanks!

[Baloo]

I haven't had to get around this yet, but the following should work (at least in theory)

Move the fields that PHP updates to a second table with a 1:1 relationship. Make that table read-only to your users then PHP won't be locked out when it needs to write.