Since two days one of our spectra applications generates the following error message on creating a new object.
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server Driver][SQL
Server]Arithmetic overflow error converting float to data type numeric.
SQL = "insert into objects (
active,archived,attribs,createdby,datetimecreated,datetimelastupdated,label,lastupdatedby,lockedby,objectid,published,typeid
) values ( ? , ? , ? , ? , ? , ? , ? , ? , null , ? , ? , ? )"
Query Parameter Value(s) -
Parameter #1 = 0
Parameter #2 = 0
Parameter #3 =
0
Parameter #4 = bibadmin
Parameter #5 = 37187.9174074
Parameter #6 =
37187.9174074
Parameter #7 = new
Parameter #8 = bibadmin
Parameter #9 =
98DDE424-840E-4F15-95CC6080758A098B
Parameter #10 = 0
Parameter #11 =
9FF02F2E-45FD-11D4-A8310050DA513E37
We are usign CF 4.5, Spectra 1.01, SQL-Server 7.0 and Win2000 sp1. The language settings are English(US) in Win2000.
Any suggestions?
Cheers,
Victor
