At 04:27 PM 14-02-02 -0600, jon-david schlough wrote:

>i'm trying to test triggers and generators in my db...
>
>when doing a simple insert i get the error:
>
>"arithmetic exception

e.g. division by zero

>numeric overflow

e.g. trying to push too large a number into a numeric type

> or string truncation"

string being inserted is longer than the declared length

>i saw the borland post on the workaround

?? workaround ??

>but i'm just doing a simple insert..!?!

A simple insert can overflow. What are you using as a client? Can you inspect your input?

>why does UDF add characters to my cute little insert?

If there is a UDF call in your insert, it's not a "simple insert". Can you provide information about the UDF and how you know that it adds characters?

>quick fixes? workarounds?

Describe the problem adequately and let's see. Database, version and client might help too.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________