Hi Joaquim,

the date format is causing problem, AFAIK you can use either
'YYYY.MM.DD' or 'MM/DD/YYYY', other formats may work as well.

best regards
Didier

Joaquim Macedo 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.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>