Luiz, Didier, Oscar - Thanks for your reply!

That's resolved - on the scripts I've changed the data format from:
DD-MM-YYYY
to:
DD.MM.YYYY


Best regards,
Joaquim.


--- In ib-support@yahoogroups.com, "Joaquim Macedo"
<joaquimmacedo@y...> wrote:

> Hi all!
>
> I'm trying to convert a MS Access database to a Firebird one.
>
> At this moment, I have scripts to create database and tables, to
> insert records on the tables, to create Foreign Keys.
>
> Please consider the following table:
> -----------------------------------------------------------------
> CREATE TABLE ASS_COBRA (
> ENT_GER_RELAC_CODIG VARCHAR( 8 ) NOT NULL
> , ENT_ENTID_RELAC_CODIG_ESPEC INTEGER NOT NULL
> , DATA_INICI TIMESTAMP NOT NULL
> , ENT_GER_RELAC_CODIG_COBRA VARCHAR( 8 )
> , ENT_ENTID_RELAC_CODIG_ESPEC_COB INTEGER
> , CONSTRAINT PK_ASS_COBRA
> PRIMARY KEY ( ENT_GER_RELAC_CODIG, ENT_ENTID_RELAC_CODIG_ESPEC,
> DATA_INICI )
> )
> -----------------------------------------------------------------
>
> 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'
> );
> -----------------------------------------------------------------
>
> I get this error message:
> -----------------------------------------------------------------
> 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?
>
>
> Thanks in advance.
>
> Best regards,
> Joaquim.