Is there a function or something I can use to check if a record is locked prior to running a script? For example, I have a script setup to charge credit cards from data in FileMaker. You push a button in the Invoice layout and it charges the card and returns data into FM via ODBC.
The problem is that if somebody else is in the record when you run the card you end up with a SQL error because the record is locked by another user. I'd like to be able to check this immediately upon the button being pushed so that if the record is locked it will display a custom diag. and allow them to run it later when the other person is out of the record instead of running the card but not being able to return data.
I can't seem to find any functions for this. Any info. would be greatly appreciated. Thanks!