err200409.txt

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

 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:43:02
user:sa
列名 'billnum' 无效。     DBCode:207
 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 getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:43:13
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 getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:46:04
user:sa
列名 'haveSend' 不明确。     DBCode:209
 update #维修站发货完成情况表 
 set notnum=tt.notnum,notbillnum=tt.notbillnum,haveupdate='y' 
 from ( 
select sum(num) as notnum,
           count(*) as notbillnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
  and  num>havesend
  and havesend='n'
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:46:07
user:sa
     DBCode:0
 update #维修站发货完成情况表 
 Set notNum=tt.notNum,notbillNum=tt.notbillNum,haveupdate='Y' 
 from ( 
select sum(num) as notnum,
           count(*) as notbillnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
  and  num>havesend
  and havesend='n'
 
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:46:25
user:sa
列名 'haveSend' 不明确。     DBCode:209
 update #维修站发货完成情况表 
 set notnum=tt.notnum,notbillnum=tt.notbillnum,haveupdate='y' 
 from ( 
select sum(num) as notnum,
           count(*) as notbillnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
  and  num>havesend
  and  getdetail.havesend='n'
 
 and  
 (getorderdate>='2004-08-01'  and getorderdate<'2004-09-01') 
 group by getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:46:27
user:sa
     DBCode:0
 update #维修站发货完成情况表 
 Set notNum=tt.notNum,notbillNum=tt.notbillNum,haveupdate='Y' 
 from ( 
select sum(num) as notnum,
           count(*) as notbillnum,
           getmain.cus_code
 from    getmain,getdetail
 
 where  getmain.orderno=getdetail.orderno
  and  num>havesend
  and  getdetail.havesend='n'
 
 and  
 (getorderdate>='2004-08-01'  and getorderdate<'2004-09-01') 
 group by getmain.cus_code
) as tt   
 where  #维修站发货完成情况表.cus_code= tt.cus_code
=================================
errordatetime:2004-09-19 13:50:33
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_code  ,tt.goo_no  ,tt.goo_name  ,tt.goo_type  ,tt.pricetype  ,tt.num  ,tt.notnum  ,tt.money  ,tt.billnum  ,tt.notbillnum  ,tt.notmoney  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #零件发货完成情况表 as tt   order by  cus_code
=================================
errordatetime:2004-09-19 13:52:22
user:sa
列前缀 'goodsno' 与查询中所用的表名或别名不匹配。     DBCode:107
insert into ##零件分类统计的入库变化表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:52:23
user:sa
     DBCode:0
insert into ##零件分类统计的入库变化表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:52:25
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.num0  ,tt.money0  ,tt.num1  ,tt.money1  ,tt.num2  ,tt.money2  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##零件分类统计的入库变化表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 13:52:55
user:sa
列前缀 'goodsno' 与查询中所用的表名或别名不匹配。     DBCode:107
insert into ##按零件统计的客户订货变化表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:52:56
user:sa
     DBCode:0
insert into ##按零件统计的客户订货变化表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:52:57
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.num0  ,tt.money0  ,tt.num1  ,tt.money1  ,tt.num2  ,tt.money2  ,tt.num3  ,tt.money3  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##按零件统计的客户订货变化表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 13:58:21
user:sa
列前缀 'goodsno' 与查询中所用的表名或别名不匹配。     DBCode:107
insert into ##零件分类综合统计表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:58:22
user:sa
     DBCode:0
insert into ##零件分类综合统计表(spid,insdate,haveupdate,goo_type1,goo_type,pricetype)
 select 1620,'2004-09-19','n',goodsno.goo_type,goodsno.goo_type,goodsno.pricetype  from  goodtype 
 group by goodsno.goo_type ,
 goodsno.goo_type ,
 goodsno.pricetype
=================================
errordatetime:2004-09-19 13:58:23
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.getordernum  ,tt.getordernum_nosend  ,tt.salenum  ,tt.buynum  ,tt.buynum_no  ,tt.inputnum  ,tt.cusbacknum  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##零件分类综合统计表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 14:00:12
user:sa
在关键字 'as' 附近有语法错误。     DBCode:156
 update ##零件分类综合统计表 
 set inputnum=tt.num,haveupdate='y' 
 from ( 
select as goo_type,sum(inm_quanty) as num 
 from  inputone,inputgoods,goodsno
 
 where  inputone.inp_no=inputgoods.inm_no
and inputgoods.inm_goods =goodsno.goo_code
 and  
 (inp_date>='2004-09-01'  and inp_date<'2004-09-20') 
 group by  goo_type
) as tt   
 where  ##零件分类综合统计表.goo_type= tt.goo_type
=================================
errordatetime:2004-09-19 14:00:22
user:sa
     DBCode:0
 update ##零件分类综合统计表 
 Set inputnum=tt.num,haveupdate='Y' 
 from ( 
select as goo_type,sum(inm_quanty) as num 
 from  inputone,inputgoods,goodsno
 
 where  inputone.inp_no=inputgoods.inm_no
and inputgoods.inm_goods =goodsno.goo_code
 and  
 (inp_date>='2004-09-01'  and inp_date<'2004-09-20') 
 group by  goo_type
) as tt   
 where  ##零件分类综合统计表.goo_type= tt.goo_type
=================================
errordatetime:2004-09-19 14:00:22
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.getordernum  ,tt.getordernum_nosend  ,tt.salenum  ,tt.buynum  ,tt.buynum_no  ,tt.inputnum  ,tt.cusbacknum  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##零件分类综合统计表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 14:00:49
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.getordernum  ,tt.getordernum_nosend  ,tt.salenum  ,tt.buynum  ,tt.buynum_no  ,tt.inputnum  ,tt.cusbacknum  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##零件分类综合统计表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 14:01:03
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.getordernum  ,tt.getordernum_nosend  ,tt.salenum  ,tt.buynum  ,tt.buynum_no  ,tt.inputnum  ,tt.cusbacknum  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  ##零件分类综合统计表 as tt   order by  typeno
=================================
errordatetime:2004-09-19 14:03:00
user:sa
列名 'pricetype' 无效。     DBCode:207
 update ##零件分类综合统计表 
 set getordernum=tt.num,getordernum_nosend=tt.nosendnum,haveupdate='y' 
 from ( 
select goo_type,sum(num) as num,sum(num-havesendnum) as nosendnum
 from  getdetail,getmain,goodsno
 
 where  getmain.orderno=getdetail.orderno
and getdetail.goo_code = goodsno.goo_code
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by  goo_type
) as tt   
 where  ##零件分类综合统计表.goo_type= tt.goo_type and ##零件分类综合统计表.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 14:03:12
user:sa
     DBCode:0
 update ##零件分类综合统计表 
 Set getordernum=tt.num,getordernum_nosend=tt.nosendnum,haveupdate='Y' 
 from ( 
select goo_type,sum(num) as num,sum(num-havesendnum) as nosendnum
 from  getdetail,getmain,goodsno
 
 where  getmain.orderno=getdetail.orderno
and getdetail.goo_code = goodsno.goo_code
 and  
 (getorderdate>='2004-09-01'  and getorderdate<'2004-09-20') 
 group by  goo_type
) as tt   
 where  ##零件分类综合统计表.goo_type= tt.goo_type and ##零件分类综合统计表.pricetype= tt.pricetype
=================================
errordatetime:2004-09-19 14:04:04
user:sa
列 'goodsno.pricetype' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。     DBCode:8120
 update ##零件分类综合统计表