I'm new to the subject Database, so I hope you understand my doubt and lack of knowledge:
We use Firebird as SGDB and IBExpert as a database administration and configuration tool. Because the application in question is used simultaneously by multiple users (performing UPDATE, DELETE and INSERT operations on the same table practically) lock conflict errors occur. I have read that by waiting a few minutes the transaction solidifies (or stopping the Database Service and starting again) and there is also the option to run the command below.
gfix -commit all
However, my question is: Is there any command that can be executed in IBExpert for example, and that confirms these transactions at the time of execution, since the connection to the Database would be remotely, not on the Server machine to can I run the command above?
Thanks in advance for your attention!