Subject Re: [ib-support] conversion error from string
Author Svein Erling Tysvær
>I've an multiuser enviroment, but my other tables (where the error not
>are used much more than this table.

OK, but do you insert as often (from as many different transactions) into
the other tables and do the transactions last equally long and run under
the same transaction isolation?

>And when this error happens for one time i can do no insert to this table
>my app is closed and started again.

That's because it is in an uncommitted transaction (I may have tried to
commit, but failed) and cannot see that someone else have inserted to the
table the value it is trying to store.

>Both, an before-insert or an after insert trigger should be in one
>with the insert-statement or not ?

Sure, they get executed within the same transaction. Use the BI trigger to
change values in the same table, and the AI trigger to make changes to
other tables.