1 of 1 people found this helpful
Database engine is locked while evaluation is happening, so you run into a dead lock.
But using FM.ExecuteFileSQLOnIdle you can have the code queued up and run when the database engine is idle.
This way we can create/delete fields or indexes.
2 of 2 people found this helpful
I appreciate your answer, but I'm not sure that's a resolution to the problem. If the plugin allows you to do those things, and effectively locks the app when you try, it's a bug in my opinion.
It either shouldn't let you do them, should throw and error, or should work.
Because your plugin has a workaround, doesn't mean it's not broken.
I completely agree. Filemaker should handle its function reliably and take care of such locking
Thank you for your posts.
All information has been sent to Development and Testing for review. When I receive any feedback, I will let you know.