Re: Error to insert in firebird

Well, in the documentation it says that if the query raises an error, returns *FALSE*. You should start calling ibase_errmsg to track where the error is. On Tue, Nov 5, 2013 at 7:34 PM, Ismael L. Donis Garcia < ismael@citricos.co.cu> wrote: > ----- Original Message ----- From: Tsvetan Nikolov >> To: Ismael L. Donis Garcia >> Cc: PHP-General >> Sent: Tuesday, November 05, 2013 12:45 PM >> Subject: Re: [PHP] Error to insert in firebird >> >> >> Do you commit your transaction? >> >> Yes > > The complete function is: > > public function actualizar($sql,$param){ > if ($this->cn){ > > //for example: > > $sql = "insert into scele (codigo, nombre) values (?, ?)"; > $param = "1, Test1"; > > $tr = ibase_trans(IBASE_WRITE,$this->cn); > $qr = ibase_prepare($tr,$param); > $this->rs = ibase_execute($sql,$param); > if ($this->rs){ > > //Evaluate this condition, but he does not enter here > > ibase_commit($tr); > } else { > ibase_rollback($tr); > return array('tipo'=>false,'texto'=>'Error de > ejecusi&oacute;n: ' > .ibase_errmsg()); > } > ibase_free_query($qr); > return array('tipo'=>true,'texto'=>''); > } else { > return array('tipo'=>false,'texto'=>'Error de > conexi&oacute;n: ' > .ibase_errmsg()); > > } > } > > Best Regards > ======== > | ISMAEL | > ======== > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >