err200409.txt

来自「delphi编写的ERP原代码事例２,供广大初学者学习参考!」· 文本 代码 · 共 1,839 行 · 第 1/5 页

 group by goods_code
) as tt   
 where  #零件销售对比分析.goo_code= tt.goo_code
=================================
errordatetime:2004-09-19 13:09:50
user:sa
列前缀 'goodsno' 与查询中所用的表名或别名不匹配。     DBCode:107
 update #零件销售对比分析 
 set num1=tt.num,money1=tt.money,haveupdate='y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goods_code as goo_code
 from  outone,outmany
 
 where  outone.out_no=outmany.out_no 
and outmany.goods_code=goodsno.goo_code

 and  
 (out_date>='2004-07-01'  and out_date<'2004-08-01') 
 group by goods_code
) as tt   
 where  #零件销售对比分析.goo_code= tt.goo_code
=================================
errordatetime:2004-09-19 13:09:55
user:sa
     DBCode:0
 update #零件销售对比分析 
 Set num1=tt.num,money1=tt.money,haveupdate='Y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goods_code as goo_code
 from  outone,outmany
 
 where  outone.out_no=outmany.out_no 
and outmany.goods_code=goodsno.goo_code

 and  
 (out_date>='2004-07-01'  and out_date<'2004-08-01') 
 group by goods_code
) as tt   
 where  #零件销售对比分析.goo_code= tt.goo_code
=================================
errordatetime:2004-09-19 13:15:48
user:sa
列前缀 'goodtype' 与查询中所用的表名或别名不匹配。     DBCode:107
insert into tt_零件类别销售对比分析(spid,insdate,haveupdate,typeno1,typename,pricetype)
 select 1618,'2004-09-19','n',goodtype.typeno,goodtype.typename,goodsno.pricetype  from  outone,outmany,customer,goodsno  
  
 where   outone.out_no=outmany.out_no and outone.cus_code=customer.cus_code and
outmany.goods_code=goodsno.goo_code

 and out_date>='2004-09-01' and out_date<'2004-09-20' 
 group by goodtype.typeno ,
 goodtype.typename ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:16:18
user:sa
     DBCode:0
insert into tt_零件类别销售对比分析(spid,insdate,haveupdate,typeno1,typename,pricetype)
 select 1618,'2004-09-19','n',goodtype.typeno,goodtype.typename,goodsno.pricetype  from  outone,outmany,customer,goodsno  
  
 where   outone.out_no=outmany.out_no and outone.cus_code=customer.cus_code and
outmany.goods_code=goodsno.goo_code

 and out_date>='2004-09-01' and out_date<'2004-09-20' 
 group by goodtype.typeno ,
 goodtype.typename ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:16:31
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 列名 'goo_no' 无效。

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.typeno1  ,tt.typename  ,tt.pricetype  ,tt.money0  ,tt.num0  ,tt.money1  ,tt.num1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  tt_零件类别销售对比分析 as tt   order by  goo_no
=================================
errordatetime:2004-09-19 13:17:58
user:sa
列名 'typeno' 无效。     DBCode:207
 update #零件类别销售对比分析 
 set num1=tt.num,money1=tt.money,haveupdate='y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.typeno as typeno
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.typeno
) as tt   
 where  #零件类别销售对比分析.goo_type= tt.typeno and #零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:18:06
user:sa
     DBCode:0
 update #零件类别销售对比分析 
 Set num1=tt.num,money1=tt.money,haveupdate='Y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.typeno as typeno
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.typeno
) as tt   
 where  #零件类别销售对比分析.goo_type= tt.typeno and #零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:18:07
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 列名 'goo_no' 无效。

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type  ,tt.pricetype  ,tt.goo_type1  ,tt.money0  ,tt.num0  ,tt.money1  ,tt.num1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #零件类别销售对比分析 as tt   order by  goo_no
=================================
errordatetime:2004-09-19 13:18:32
user:sa
列名 'typeno' 无效。     DBCode:207
 update tt_零件类别销售对比分析 
 set num1=tt.num,money1=tt.money,haveupdate='y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.typeno as typeno
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.typeno
) as tt   
 where  tt_零件类别销售对比分析.goo_type= tt.goo_type and tt_零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:19:02
user:sa
     DBCode:0
 update tt_零件类别销售对比分析 
 Set num1=tt.num,money1=tt.money,haveupdate='Y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.typeno as typeno
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.typeno
) as tt   
 where  tt_零件类别销售对比分析.goo_type= tt.goo_type and tt_零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:19:04
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 列名 'goo_no' 无效。

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type  ,tt.pricetype  ,tt.goo_type1  ,tt.money0  ,tt.num0  ,tt.money1  ,tt.num1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  tt_零件类别销售对比分析 as tt   order by  goo_no
=================================
errordatetime:2004-09-19 13:19:27
user:sa
列名 'goo_tytpe' 无效。     DBCode:207
 update #零件类别销售对比分析 
 set num1=tt.num,money1=tt.money,haveupdate='y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.goo_tytpe 
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.goo_tytpe
) as tt   
 where  #零件类别销售对比分析.goo_type= tt.goo_type and #零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:19:30
user:sa
     DBCode:0
 update #零件类别销售对比分析 
 Set num1=tt.num,money1=tt.money,haveupdate='Y' 
 from ( 
select sum(num) as num,
           sum(price*num) as money,
           goodsno.pricetype as pricetype,
           goodsno.goo_tytpe 
 from  outone,outmany,goodsno
 
 where  outone.out_no=outmany.out_no 
   and outmany.goods_code=goodsno.goo_code and  
 (out_date>='2004-09-01'  and out_date<'2004-10-01') 
 group by goodsno.pricetype ,
 goodsno.goo_tytpe
) as tt   
 where  #零件类别销售对比分析.goo_type= tt.goo_type and #零件类别销售对比分析.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 13:19:37
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 列名 'goo_no' 无效。

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type  ,tt.pricetype  ,tt.goo_type1  ,tt.money0  ,tt.num0  ,tt.money1  ,tt.num1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #零件类别销售对比分析 as tt   order by  goo_no
=================================
errordatetime:2004-09-19 13:20:11
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 列名 'goo_no' 无效。

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type  ,tt.pricetype  ,tt.goo_type1  ,tt.money0  ,tt.num0  ,tt.money1  ,tt.num1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #零件类别销售对比分析 as tt   order by  goo_no
=================================
errordatetime:2004-09-19 13:39:03
user:sa
在用于 GROUP BY 子句分组依据列表的表达式中，不能使用聚合或子查询。     DBCode:144
 update #维修站发货完成情况表 
 set num=tt.num,billnum=tt.billnum,haveupdate='y' 
 from ( 
select sum(num) as num,
           count(*) as billnum
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by count(*)
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:39:08
user:sa
     DBCode:0
 update #维修站发货完成情况表 
 Set num=tt.num,billnum=tt.billNum,haveupdate='Y' 
 from ( 
select sum(num) as num,
           count(*) as billnum
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by count(*)
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:39:37
user:sa
在用于 GROUP BY 子句分组依据列表的表达式中，不能使用聚合或子查询。     DBCode:144
 update #维修站发货完成情况表 
 set num=tt.num,billnum=tt.billnum,haveupdate='y' 
 from ( 
select sum(num) as num,
           count(*) as billnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by count(*) ,
 getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:39:44
user:sa
     DBCode:0
 update #维修站发货完成情况表 
 Set num=tt.num,billnum=tt.billNum,haveupdate='Y' 
 from ( 
select sum(num) as num,
           count(*) as billnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by count(*) ,
 getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:42:03
user:sa
在用于 GROUP BY 子句分组依据列表的表达式中，不能使用聚合或子查询。     DBCode:144
 update #维修站发货完成情况表 
 set num=tt.num,billnum=tt.billnum,haveupdate='y' 
 from ( 
select sum(num) as num,
           count(*) as billnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by count(*) ,
 getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:42:14
user:sa
     DBCode:0
 update #维修站发货完成情况表 
 Set num=tt.num,billnum=tt.billNum,haveupdate='Y'