RogerioSilva
asked on
ODBC SQL
hi,
How can I insert data into my ODBC database ?
I'm using:
LPCSTR szSQL="INSERT INTO PRINCIPAL (v1,v2,v3,v4,v5,v6,v7,v8,v 9,va) VALUES ('a','b','c','d','e','f',' g','h','i' ,'j')";
SQLPutData(hstmt,(unsigned char*)szSQL, SQL_NTS);
SQLExecute(hstmt);
Don't work!
How can I insert data into my ODBC database ?
I'm using:
LPCSTR szSQL="INSERT INTO PRINCIPAL (v1,v2,v3,v4,v5,v6,v7,v8,v
SQLPutData(hstmt,(unsigned
SQLExecute(hstmt);
Don't work!
ASKER
I tried:
LPCSTR szSQL="INSERT INTO PRINCIPAL (v1,v2,v3,v4,v5,v6,v7,v8,v 9,va) VALUES ('a','b','c','d','e','f',' g','h','i' ,'j')";
SQLPrepare(hstmt,(unsigned char*)szSQL, SQL_NTS);
SQLBindParameter(hstmt,1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, "HERE", 0, &v2);
SQLExecute(hstmt);
But, Don't work.
LPCSTR szSQL="INSERT INTO PRINCIPAL (v1,v2,v3,v4,v5,v6,v7,v8,v
SQLPrepare(hstmt,(unsigned
SQLBindParameter(hstmt,1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, "HERE", 0, &v2);
SQLExecute(hstmt);
But, Don't work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This does't work , i'll send you source code, maybe you don't open ODBC corectly
Mistake , if this doesn't work(I mean):-)
ASKER
Thank You!
SQLBindParameter(m_hstmt,.
<load data>
SQLExecute(m_hstmt);
would work.
Thanks,