svanderclock wrote:

> yes, i was thinking to do like you say, handle the error in the
> client interface... but is not a problem for firebird to receive too
> lot of error like this (duplicate reccord or lock conflict?)

Primary key violation error is quite normal event and there is no harm done.

> in case of error, is it better for the stability of firebird to
> commit the transaction or rollback it (nothing was inserted or
> updated cause of the error)

I believe it is better to commit, but someone might correct me on that one.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com