I don't see any SQL, but this error message is typical if you try to divide by zero or put too long a string into too short a field (like trying to put 'Yes' into a CHAR(1) field).

It can also be that a number gets too big, but that is more unusual.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-suptport@yahoogroups.com] On Behalf Of helloise.smit
Sent: 24. november 2009 12:43
To: firebird-support@yahoogroups.com
Subject: [firebird-support] arithmetic exception, numeric overflow, or string truncation ????

i run the following sql on a fb db and get the error above?
what does it mean pls?