我想要做的是一个联合删除,删除和一条记录有关的所有数据,他们的主键都一样,语句如下面,我想在adocommand中作,如果像下面写法的话,adocommand就会当作6个参数处理,请问怎么才能合为一个参数(我用的是Access库,好像不支持存储过程)
delete table1 where mid(gcjybh,1,8)=:bh
delete table2 where mid(gcjybh,1,8)=:bh
delete table3 where mid(gcjybh,1,8)=:bh
delete table4 where mid(gcjybh,1,8)=:bh
delete table5 where mid(gcjybh,1,8)=:bh
delete table5 where mid(gcjybh,1,8)=:bh
delete table1 where mid(gcjybh,1,8)=:bh
delete table2 where mid(gcjybh,1,8)=:bh
delete table3 where mid(gcjybh,1,8)=:bh
delete table4 where mid(gcjybh,1,8)=:bh
delete table5 where mid(gcjybh,1,8)=:bh
delete table5 where mid(gcjybh,1,8)=:bh
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货