Subject | FB 3.0 SQL Error. |
---|---|
Author | Hugo Eyng |
Post date | 2014-12-23T17:25:55Z |
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?
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