删除父表的时候怎么判断子表是否有相应记录,
例如我要删除
bSql = "Delete From tixzl Where txbh='"+ctxbh+"'";
m_AdoConn.ExecuteSQL(bSql);
得先判断txbh在子表stxx是否有记录,
bSql ="SELECT count(*) as NUM FROM stxx where txbh='"+sclassid+"'";
m_AdoConn.ExecuteSQL(bSql);
可我怎么样才能有个int ncount来统计这个“NUM”呢?
ncount=???NUM???
例如我要删除
bSql = "Delete From tixzl Where txbh='"+ctxbh+"'";
m_AdoConn.ExecuteSQL(bSql);
得先判断txbh在子表stxx是否有记录,
bSql ="SELECT count(*) as NUM FROM stxx where txbh='"+sclassid+"'";
m_AdoConn.ExecuteSQL(bSql);
可我怎么样才能有个int ncount来统计这个“NUM”呢?
ncount=???NUM???
m_rs = m_AdoConn.ExecuteSQL(bSql); //m_rs是个ADO 记录集
取出rs中的记录值就可以了
//m_rs是个ADO 记录集 ??
怎么声明啊?
又怎么取出记录值啊?ncount =(long)m_pRecordset->GetCollect("NUM");
这样可以吗?
不过好象一直提示出错啊