Hi, I'm trying to insert a row:

INSERT INTO TEMPORALPRUEBA1 (
CLIENTID, DATE2, DATE1, GENE
) VALUES (
1, '01/01/2007', '13/01/2007', GEN_ID(GENIDFECH,1) );

in this table:
CREATE TABLE TEMPORALPRUEBA1 (
CLIENTID INTEGER,
DATE2 DATE,
DATE1 DATE,
GENE INTEGER NOT NULL);
ALTER TABLE TEMPORALPRUEBA1 ADD CONSTRAINT INTEG_1199 PRIMARY KEY (GENE);

I get the error:
Overflow occurred during data type conversion.Conversion error from string "13/01/2007".

It is because it tries to insert '01/13/2007'

To insert 13/01/2007 I have to insert 01/13/2007 when do you set that? In the environmental options the DATE is set to dd/MM/yyyy why does it insert in reverse order the day and the month?
It's InterBase 7.5




---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]