rc=SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt);
for(int i=0;i<10;i++)
{
sprintf( szSql,"INSERT INTO RecordTable(recordTime,finder,taskID) VALUES('%s',%s,%d)",cTime,Finder,TaskID);
rc = ::SQLExecDirect(hstmt, (unsigned char*)szSql, SQL_NTS);sprintf(strCheck,"UPDATE TaskTable SET taskState='已完成' WHERE TaskID=%d",TaskID);
rc = ::SQLExecDirect(hstmt, (unsigned char*)strCheck, SQL_NTS);
}低一个可以执行,但是第二个总是报错--SQL_NO_DATA,怎么回事?
for(int i=0;i<10;i++)
{
sprintf( szSql,"INSERT INTO RecordTable(recordTime,finder,taskID) VALUES('%s',%s,%d)",cTime,Finder,TaskID);
rc = ::SQLExecDirect(hstmt, (unsigned char*)szSql, SQL_NTS);sprintf(strCheck,"UPDATE TaskTable SET taskState='已完成' WHERE TaskID=%d",TaskID);
rc = ::SQLExecDirect(hstmt, (unsigned char*)strCheck, SQL_NTS);
}低一个可以执行,但是第二个总是报错--SQL_NO_DATA,怎么回事?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货