Hi everyone!
Can someone tell me how I can lock for writing an Interbase database / all tables in a database.
I have the following case:
My php script updates a database with lots of changes, which are better not to be interfered by somebody else's actions in the same time. That's why I need to lock all tables for writing (that's the easier option, but I can build a list of tables that need to be locked).
I saw that there's an ibase_trans() function in the PHP but I find the documentation very poor and unable to understand the modes. 😕
I believe this is the first option to do this, but I am not sure which mode exactly I should run.
The second option is some SQL statement (SET TRANSACTION ...) but I need the options again 🙂
Thanks a lot!
Stefank