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
