int delete_rec(char *deletesql, int serial_no, int priority,int relation_no) { int v_serial_no; int v_priority; char msg[128]; int v_relation_no; //modify by changhong 20050427 v_serial_no=serial_no; v_priority=priority; v_relation_no=relation_no; cr.clearhp(3);
//printf("delete sub table data:[%s][%d][%d]\n",deletesql,v_serial_no,v_priority);
{
int v_serial_no;
int v_priority;
char msg[128];
int v_relation_no; //modify by changhong 20050427 v_serial_no=serial_no;
v_priority=priority;
v_relation_no=relation_no;
cr.clearhp(3);
//printf("delete sub table data:[%s][%d][%d]\n",deletesql,v_serial_no,v_priority);
if(cr.prepare((text*)deletesql,(ub4) strlen((char *)deletesql)))
{
sprintf(msg,"prepare error");
tool.DealInfo(CRIT,msg,0);
return ERROR;
}
if(cr.execute( 1, 0))
{
sprintf(msg,"execute error");
tool.DealInfo(CRIT,msg,0);
return ERROR;
}
return OK;
}
Stmt->setSQL(strsql);
count=Stmt->executeUpdate();
Conn->commit();
Conn->terminateStatement(Stmt);
这样的代码接口比较简单,但上面的代码只可以插入,删除不了数据,不知为什么?