To make updates on firebird database is mandatory a transactional management.
I have Database opened, a datesat connected to that database, and now there are some standard solutions, AFAIK:
- startTransaction, Edit, change field value, post, committransaction.
- startTransaction, update query ("UPDATE ... SET ... WHERE ...), committransaction
- writing code from scratch using ibase* functions
In a JSButtonClick event code, solutions 1. and 2. don't give errors, but simply do nothing!
I searched where code do transaction management... and found in dbtables.inc.php
PHP Code:
class Database extends CustomConnection
{
/* ...some code here... */
function beginTrans()
{
$this->_connection->StartTrans();
}
function completeTrans($autocomplete=true)
{
return($this->_connection->CompleteTrans($autocomplete));
}
/* ... some other code here ... */
$this->_connection = ADONewConnection($this->DriverName);
So I must investigate what happens in ADOdb.
I've seen videos demonstrating development in mysql, but there's no transactional management.
Any hint?