Hi,

You can use a stored procedure to centralize the update, in the proc,
check the total debit against credit, if not balance trigger an
exception, in the program side, you can handle that exception.

frank

--- In firebird-support@yahoogroups.com, Thierry Holtzmann
<tholtzmann@n...> wrote:

> In accounting programs, we have debit records and credit records and
> they have to be balanced. Is there a way at the database level to

verify

> this, and to avoid committing a transaction involving unbalanced

records ?

> Or at least can we query a list of records in instance of a transaction
> commit ?