At 10:23 AM 24/05/2004 -0300, you wrote:

>I think the problem is about decimal places, can I use this?
>
>CREATE DOMAIN D_MOEDA AS
>NUMERIC(16,5)
>DEFAULT 0
>CHECK (VALUE BETWEEN -99999999999999.99 AND +99999999999999.99)
>
>I need to use at least 5 decimal places with DEFAUTL to 0.00, which is the
>best type for that?

The check constraint is out of range - that is why you are getting the
overflow error. The maximum precision of NUMERIC is 18; with a scale of 5,
your numbers resolve to a precision of 19. Additionally, you declared your
number with a precision of 16, not 18 (although Firebird stores it as 18,
your check isn't valid for a numeric(16)).

Change your check to

CHECK (VALUE BETWEEN -99999999999.99999 AND +99999999999.99999)

This question is off-topic for this list, btw.

Helen