Ok, mea culpa, mea culpa, mea maxima culpa !!! A have a dozen of parameters declared in my dbproc and I have just declared wrong size of parameter just before the float one (shoud be SQLSMALLINT, was SQLINTEGER). Sorry...
Best regards Janusz Jeczmionka > Hi Janusz > > Just I tried to reproduce the problem, but I could insert SQLFLOAT values > as expected. > Please send me a small test program showing the described effect. > > > Regards Thomas > > > ---------------------------------------------- > Dr. Thomas Kötter > SAP DB, SAP Labs Berlin > > > SAP DB is open source. Get it! www.sapdb.org > > > > > > > -----Original Message----- > > From: Janusz Jeczmionka [mailto:[EMAIL PROTECTED]] > > Sent: Freitag, 31. Januar 2003 11:54 > > To: [EMAIL PROTECTED] > > Subject: FLOAT and ODBC > > > > > > > > Hi all, > > > > can anybody tell me why i get following error: > > > > [SAP AG][SQLOD32 DLL][SAP DB]Numeric value out of range;-3019 POS (49) > > Invalid exponent. > > > > when i try to bind parameter of db procedure of type float > > and execute > > query. > > > > SQLFLOAT value = 1.0; //maps to double value = 1.0; > > . > > . > > SQLBindParameter( sql_h_stmt, 11, SQL_PARAM_INPUT, SQL_C_DOUBLE, > > SQL_FLOAT, 16, 0, (SQLPOINTER) &value, 0, NULL ); > > . > > . > > SQLExecute( sql_h_stmt ); > > . > > . > > I use ODBC driver 7.4 and server 7.3.0.30 and 7.4.3.10 > > > > Greetings, > > Janusz Jeczmionka > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
