用VC做SQL的大虾来看看!
一个VC的MFC程序,用SQL查询!用的是ACESS数据库!
出错程序如下!
#define ID_LEN 3
SQLINTEGER length2[20];
SQLCHAR title2[20];
CHAR szID[ID_LEN];
SQLINTEGER cbID=SQL_NTS;
sqlreturn=SQLPrepare(hstmt,(UCHAR*)"SELECT * FROM paramet WHERE djxh=?",SQL_NTS);
sqlreturn=SQLBindParameter(hstmt,1,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,ID_LEN,0,szID,0,&cbID);
sprintf(szID,m_djxhselected);
sqlreturn=SQLExecute(hstmt);
sqlreturn=SQLBindCol(hstmt,1,SQL_C_CHAR,title2,sizeof(title2),&length2[0]);
SQLSetStmtAttr(hstmt,SQL_ATTR_ROWS_FETCHED_PTR,&RowCount,0);
m_djmemo.SetWindowText(CString(title2));
但在title2中最后得到的是很多的"汤汤……"
不知道出错在哪,请各位高手帮忙!