2,209
社区成员
发帖
与我相关
我的任务
分享下面代码不知哪里有错请赐教
set term^
create trigger Del_ZCData FOR ZCDATA after delete as
begin
if (Quantity - old.NewQty = 0) then
delete from stock
WHERE WAREHOUSEID = old.newWAREHOUSERID
AND MATERIALID = old.MATERIALID
AND ORDERID = old.NEWORDERID
AND COLORID = old.COLORID
AND SIZENAME = old.SIZENAME;
end^
create trigger Del_ZCData FOR ZCDATA after delete as
begin
if (Quantity - old.NewQty = 0) then
delete from stock
WHERE WAREHOUSEID = old.newWAREHOUSERID
AND MATERIALID = old.MATERIALID
AND ORDERID = old.NEWORDERID
AND COLORID = old.COLORID
AND SIZENAME = old.SIZENAME;
end^
...全文
请发表友善的回复…
发表回复
CuteBit 2003-02-21
- 打赏
- 举报
请具体些，一点不懂你遇到的问题 :(
touch666 2003-02-21
- 打赏
- 举报
问题是:当我删除一个表项时,另一个表的表项当其数量为0时则将全部删除,
quantity和newQTy都是数量.ZCDATA - > newQTy , stock - > quantity
quantity和newQTy都是数量.ZCDATA - > newQTy , stock - > quantity
CuteBit 2003-02-21
- 打赏
- 举报
Quantity 是什么东东？
如果我假设你可能是这样的（你如果具体描述问题，更有助帮你解决问题）
set term^
create trigger Del_ZCData FOR ZCDATA after delete as
/* add */
DECLARE VARIABLE Quantity INTEGER;
begin
/* add */
select [field] from [table] where [condition] into :Quantity;
if (Quantity - old.NewQty = 0) then
delete from stock
WHERE WAREHOUSEID = old.newWAREHOUSERID
AND MATERIALID = old.MATERIALID
AND ORDERID = old.NEWORDERID
AND COLORID = old.COLORID
AND SIZENAME = old.SIZENAME;
end^
如果我假设你可能是这样的（你如果具体描述问题，更有助帮你解决问题）
set term^
create trigger Del_ZCData FOR ZCDATA after delete as
/* add */
DECLARE VARIABLE Quantity INTEGER;
begin
/* add */
select [field] from [table] where [condition] into :Quantity;
if (Quantity - old.NewQty = 0) then
delete from stock
WHERE WAREHOUSEID = old.newWAREHOUSERID
AND MATERIALID = old.MATERIALID
AND ORDERID = old.NEWORDERID
AND COLORID = old.COLORID
AND SIZENAME = old.SIZENAME;
end^
