Link to home
Start Free TrialLog in
Avatar of RogerioSilva
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,v9,va) VALUES ('a','b','c','d','e','f','g','h','i','j')";
SQLPutData(hstmt,(unsigned char*)szSQL, SQL_NTS);
SQLExecute(hstmt);

 Don't work!
Avatar of thinoo
thinoo

SQLPrepare(m_hstmt,(UCHAR*)SQLString),SQL_NTS);
SQLBindParameter(m_hstmt,...,)
<load data>
SQLExecute(m_hstmt);

would work.

Thanks,
Avatar of RogerioSilva

ASKER

I tried:

LPCSTR szSQL="INSERT INTO PRINCIPAL (v1,v2,v3,v4,v5,v6,v7,v8,v9,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.
ASKER CERTIFIED SOLUTION
Avatar of cybsasha
cybsasha

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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):-)
Thank You!