Subject FB 3.0 SQL Error.
Author Hugo Eyng
Hello Friends.

In FB 3.0.0 I received the error message: Name longer than database column size.

SELECT I.CD_TIPO_MOVIMENTO_ESTOQUE AS CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA
FROM MyTable

CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA (31 characters large)

Ok. I Understood the message. My column has more than 30 characters.

But, in FB 2.5 , a column larger than 30 characters was truncated or replaced by a number
at the end of the column name.
CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA ->CD_TIPO_MOVIMENTO_ESTOQUE_COMPR
or
CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA -> CD_TIPO_MOVIMENTO_ESTOQUE_COMP1
to avoid duplication field.

Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in this situation?

-- 


Atenciosamente,

Hugo Eyng