Hi,
I seem unable to use ODBC Prepared statements to write data into columns of type
INTEGER i.e. FIXED 20,0.
I always get a --> -802 Invalid numeric input parameter value
on executing the prepared statement.
Should'nt the driver do appropriate conversions?
Note: OS windows 2000
SQLMODE ORACLE
ODBC version 2.0
The table creation statement was:
CREATE TABLE TEST (c1 INTEGER)
The code looks like this:
int integerval=4321;
retcode = SQLPrepare(m_stmt, (SQLCHAR *)"Insert into test values(?)",
(SQLINTEGER)strlen("Insert into test values(?)"));
retcode = SQLBindParameter(m_stmt, 1,SQL_PARAM_INPUT,
SQL_C_SLONG,
SQL_INTEGER,
0, 0,
SQLPOINTER)&integerval,
sizeof(integerval),0);
retcode = SQLExecute(m_stmt);
Mail me if you want my test program.
Regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
