Re: Invalid scale for DECIMAL datatype
Posted in 2004
Sergei Turin — — source: Usenet: comp.databases.informix
Hi Tsutomi, Thanks, first solution is OK for me. Tables with DECIMAL columns are know attachable. Second option has been tested previously (with and without "Report only standard ODBC data type" toggle) with no success. Thanks again, Sergei "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<cib3oo$84b$1@news.xmission.com>... > Hi Sergei. > > Try as bellow. > > Change decimal(10) to decimal(10,0) > OR > Check "Describe Decimal Floating Point as SQL REA/ SQL DOUBLE" under > Advanced of Informix ODBC Driver Setup. > > Hope this helps. > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592