22,209
社区成员
发帖
与我相关
我的任务
分享想哭，不知错在那？
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
...全文
请发表友善的回复…
发表回复
misfans 2003-04-07
- 打赏
- 举报
把下面這段先去掉，然後在前段測試POST,
再把這句加到裡面單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
再把這句加到裡面單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
bosshoss 2003-04-07
- 打赏
- 举报
顶
bosshoss 2003-04-07
- 打赏
- 举报
我这个是放在触发器中，
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail
FOR INSERT
AS
这一句没有问题，调试时
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from inserted
一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail
FOR INSERT
AS
这一句没有问题，调试时
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from inserted
一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
PhilexPei 2003-04-07
- 打赏
- 举报
关注
misfans 2003-04-07
- 打赏
- 举报
把下面這段先去掉，然後在前段測試POST,
再把這句放到sqlserver analyze裡手動單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
再把這句放到sqlserver analyze裡手動單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
bosshoss 2003-04-07
- 打赏
- 举报
顶
bosshoss 2003-04-07
- 打赏
- 举报
我这个是放在触发器中，一加这一句，前端程序新增时，死在那：
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail
FOR INSERT
AS
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from inserted
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail
FOR INSERT
AS
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from inserted
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
pengdali 2003-04-07
- 打赏
- 举报
报什么错？
bosshoss 2003-04-07
- 打赏
- 举报
没有啊，只有orderform(订单表)的orderformid为主键，还有nodeliverydetail 没有设主键
也没有做触发器
也没有做触发器
bosshoss 2003-04-07
- 打赏
- 举报
我要数据库的，在那个地方!
caiyunxia 2003-04-07
- 打赏
- 举报
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
是否有一对多的，主键重复？
select o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
是否有一对多的，主键重复？
bosshoss 2003-04-07
- 打赏
- 举报
我要数据库的，在那个地方!
bosshoss 2003-04-07
- 打赏
- 举报
我要数据库的，在那个地方!
acykm 2003-04-07
- 打赏
- 举报
在企业管理器 SERVER 的管理里面可以看日志（用sa登录).
bosshoss 2003-04-07
- 打赏
- 举报
删除前一句，测试通不过，没用!
我用的是MSSQL2000，日志在那看？
我用的是MSSQL2000，日志在那看？
