char ch[20];
for(int i=0;i<10;i++) db_str[i].Format("%d",84);
sqlstr="INSERT INTO dydata VALUES("+db_str[0]+","+db_str[1]+","+db_str[2]+","+db_str[3]+","+db_str[4]+","+db_str[5]+","+db_str[6]+","+db_str[7]+","+db_str[8]+","+db_str[9]+")";
memcpy(ch,sqlstr,20);
rc=::SQLExecDirect(hstmt,(unsigned char*)ch,SQL_NTS);
运行后rc返回值为-1.
请各位大侠帮忙看看,谢谢了
for(int i=0;i<10;i++) db_str[i].Format("%d",84);
sqlstr="INSERT INTO dydata VALUES("+db_str[0]+","+db_str[1]+","+db_str[2]+","+db_str[3]+","+db_str[4]+","+db_str[5]+","+db_str[6]+","+db_str[7]+","+db_str[8]+","+db_str[9]+")";
memcpy(ch,sqlstr,20);
rc=::SQLExecDirect(hstmt,(unsigned char*)ch,SQL_NTS);
运行后rc返回值为-1.
请各位大侠帮忙看看,谢谢了
解决方案 »
- 为什么在用ado访问text型blob数据,访回类型总是_bstr_t型?
- windows编程书籍
- *** 发现一个严重的问题: DLL中的全局共享变量分配的内存, 谁来释放??? (欢迎讨论)
- 求在单文档的右下方(非对话框)创建多个标签的例子!
- 理论问题,请赐教。(抱歉,我实在是没有分了)
- 怎样接收网卡发出的信息?
- 那有《设计模式》的书下载????
- MFC中如何对一个结构体数组(结构体成员是一个int型数据和5个CString类成员)进行文件读写操作?
- installshield for vc++如何使用,为什么不拷贝程序文件?
- 急!!!那里 有 XteamLindows 的 下载???
- 用什么数据类型保存Access中的Counter类型的字段啊?
- 请求给予VC++帮助
sprintf( ch,
"INSERT INTO dydata VALUES('+%s+','+%s+', ...)",
db_str[0], db_str[1], ...
);
rc=::SQLExecDirect(hstmt, (unsigned char*)ch, SQL_NTS);
char ch[2048+1];
sprintf( ch,
"INSERT INTO dydata (字段1,字段1,...) VALUES('+%s+','+%s+', ...)",
db_str[0], db_str[1], ...
);
rc=::SQLExecDirect(hstmt, (unsigned char*)ch, SQL_NTS);2.
char ch[2048+1];
sprintf( ch,
"INSERT INTO dydata (字段1,字段2,...) VALUES('%s','%s', ...)",
db_str[0], db_str[1], ...
);
rc=::SQLExecDirect(hstmt, (unsigned char*)ch, SQL_NTS);字符型字段才需要加'%s'错误时用下面代码看看错误信息,在szMsg里。
BYTE szState[64], szMsg[256];
SQLINTEGER iNativeError;
SQLSMALLINT iRetLen;
SQLRETURN iRetCode;
memset( szState, 0, sizeof(szState) );
memset( szMsg, 0, sizeof(szMsg) );
iRetCode = SQLGetDiagRec(SQL_HANDLE_STMT, hStmt, 1,
(BYTE *) szState, &iNativeError, (BYTE *) szMsg, 256, &iRetLen
);