----- Original Message -----
From: "Joaquim Macedo" <joaquimmacedo@...>
> When inserting the record:
> -----------------------------------------------------------------
> INSERT INTO ASS_cobra (
> data_inici,
> ENT_entid_relac_codig_espec,
> ENT_entid_relac_codig_espec_cob,
> ENT_GER_relac_codig,
> ENT_GER_relac_codig_cobra
> ) VALUES (
> '22-01-1990',
> 3,
> 3,
> 'ASSOC',
> 'COBR'
> );
> -----------------------------------------------------------------
> SQL ERROR CODE:-413
>
> SQL ERROR MESSAGE:
> Overflow occurred during data type conversion.
> -----------------------------------------------------------------
>
> On IB_SQL I get:
> conversion error from string "22-01-1990"
>
>
> Why can I insert some records to this table, and this don't?

Your date format is not valid to database:

Try this date format: '1990.01.22'.

There are others valid formats, but I have used this.

Luiz.