err200409.txt

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

程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file w_sale_nextbill is out of date, must be converted to current version at line 1 in close event of object w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = w_sellbill_query.
Script = close.
Line in Script = 1.
=================================
errordatetime:2004-09-14 16:56:41
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file w_sale_nextbill is out of date, must be converted to current version at line 1 in close event of object w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = w_sellbill_query.
Script = close.
Line in Script = 1.
=================================
errordatetime:2004-09-14 17:05:43
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file w_sale_nextbill is out of date, must be converted to current version at line 4 in rowfocuschanged event of object dw_result of w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = dw_result.
Script = rowfocuschanged.
Line in Script = 4.
=================================
errordatetime:2004-09-14 17:07:04
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file w_sale_nextbill is out of date, must be converted to current version at line 1 in close event of object w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = w_sellbill_query.
Script = close.
Line in Script = 1.
=================================
errordatetime:2004-09-14 17:17:03
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file w_sale_nextbill is out of date, must be converted to current version at line 1 in close event of object w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = w_sellbill_query.
Script = close.
Line in Script = 1.
=================================
errordatetime:2004-09-17 15:01:06
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file m_tools_menu is out of date, must be converted to current version at line 2 in clicked event of object cb_1 of w_status..
Window/Menu/Object = w_status.
Error Object/Control = cb_1.
Script = clicked.
Line in Script = 2.
=================================
errordatetime:2004-09-17 15:27:14
user:sa

=================================
errordatetime:2004-09-17 15:28:26
user:sa

=================================
errordatetime:2004-09-17 15:31:05
user:sa

=================================
errordatetime:2004-09-17 15:31:52
user:sa

=================================
errordatetime:2004-09-17 15:31:59
user:sa
程序出错，请与开发人员联系 
Error Number 11.
Error text = Object file m_tools_menu is out of date, must be converted to current version at line 2 in clicked event of object cb_1 of w_status..
Window/Menu/Object = w_status.
Error Object/Control = cb_1.
Script = clicked.
Line in Script = 2.
=================================
errordatetime:2004-09-17 15:32:07
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_design_dw_result at line 16 in function gf_openwinbytext of object gf_openwinbytext..
Window/Menu/Object = gf_openwinbytext.
Error Object/Control = gf_openwinbytext.
Script = gf_openwinbytext.
Line in Script = 16.
=================================
errordatetime:2004-09-17 15:48:27
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 对象名 'subcom' 无效。

出错对象:n_tr
父对象:w_wordbook_find
datawindow:dw_subcom
语法:select *  from subcom
=================================
errordatetime:2004-09-17 15:48:33
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 对象名 'subcom' 无效。

出错对象:n_tr
父对象:w_wordbook_find
datawindow:dw_subcom
语法:select *  from subcom
=================================
errordatetime:2004-09-18 11:00:20
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_sell_input_dyb
datawindow:dw_sell_input_main_dyb
语法:  SELECT store.sto_code,              store.sto_name,              store.ishavepos,           subno,billno       FROM store      
=================================
errordatetime:2004-09-18 11:01:52
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
违反了 PRIMARY KEY 约束 'PK_store'。不能在对象 'store' 中插入重复键。

No changes made to database.

INSERT INTO store ( sto_code, sto_name, subno, billno ) VALUES ( 'A1', 'A1', 'HK', 'LH' )

出错对象:n_tr
父对象:w_store_de
datawindow:dw_store_dyb
语法:INSERT INTO store ( sto_code, sto_name, subno, billno ) VALUES ( 'A1', 'A1', 'HK', 'LH' )
=================================
errordatetime:2004-09-18 11:03:26
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 89 in itemchanged event of object dw_main of w_input..
Window/Menu/Object = w_input.
Error Object/Control = dw_main.
Script = itemchanged.
Line in Script = 89.
=================================
errordatetime:2004-09-18 11:03:59
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 1 in clicked event of object cb_selected of w_input..
Window/Menu/Object = w_input.
Error Object/Control = cb_selected.
Script = clicked.
Line in Script = 1.
=================================
errordatetime:2004-09-18 11:04:33
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 1 in clicked event of object cb_selected of w_input..
Window/Menu/Object = w_input.
Error Object/Control = cb_selected.
Script = clicked.
Line in Script = 1.
=================================
errordatetime:2004-09-18 18:01:05
user:sa

=================================
errordatetime:2004-09-19 12:12:44
user:sa
数据库发生错误.


错误代码:  207

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

错误行数:0
n_ds 错误Dataobject:dw_statway_cond_save
错误的SQL:  select mydwstatway_condsysset.statcode,   
         mydwstatway_condsysset.dbcond,   
         mydwstatway_condsysset.condname,   
         mydwstatway_condsysset.condid,   
         mydwstatway_condsysset.operator,   
         mydwstatway_condsysset.dbname,   
         mydwstatway_condsysset.dbtype,   
         mydwstatway_condsysset.collen,   
         mydwstatway_condsysset.initvalue,   
         mydwstatway_condsysset.sub_keycode  ,
         mydwstatway_condsysset.subsql1 ,
         mydwstatway_condsysset.subsql2 
    from mydwstatway_condsysset  
   where mydwstatway_condsysset.statcode = 'G'  
  

=================================
errordatetime:2004-09-19 12:13:01
user:sa
数据库发生错误.


错误代码:  207

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

错误行数:0
n_ds 错误Dataobject:dw_statway_cond_save
错误的SQL:  select mydwstatway_condsysset.statcode,   
         mydwstatway_condsysset.dbcond,   
         mydwstatway_condsysset.condname,   
         mydwstatway_condsysset.condid,   
         mydwstatway_condsysset.operator,   
         mydwstatway_condsysset.dbname,   
         mydwstatway_condsysset.dbtype,   
         mydwstatway_condsysset.collen,   
         mydwstatway_condsysset.initvalue,   
         mydwstatway_condsysset.sub_keycode  ,
         mydwstatway_condsysset.subsql1 ,
         mydwstatway_condsysset.subsql2 
    from mydwstatway_condsysset  
   where mydwstatway_condsysset.statcode = 'G'  
  

=================================
errordatetime:2004-09-19 12:13:38
user:sa
数据库发生错误.


错误代码:  207

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

错误行数:0
n_ds 错误Dataobject:dw_statway_cond_save
错误的SQL:  select mydwstatway_condsysset.statcode,   
         mydwstatway_condsysset.dbcond,   
         mydwstatway_condsysset.condname,   
         mydwstatway_condsysset.condid,   
         mydwstatway_condsysset.operator,   
         mydwstatway_condsysset.dbname,   
         mydwstatway_condsysset.dbtype,   
         mydwstatway_condsysset.collen,   
         mydwstatway_condsysset.initvalue,   
         mydwstatway_condsysset.sub_keycode  ,
         mydwstatway_condsysset.subsql1 ,
         mydwstatway_condsysset.subsql2 
    from mydwstatway_condsysset  
   where mydwstatway_condsysset.statcode = 'G'  
  

=================================
errordatetime:2004-09-19 12:14:30
user:sa
数据库发生错误.


错误代码:  207

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

错误行数:0
n_ds 错误Dataobject:dw_statway_cond_save
错误的SQL:  select mydwstatway_condsysset.statcode,   
         mydwstatway_condsysset.dbcond,   
         mydwstatway_condsysset.condname,   
         mydwstatway_condsysset.condid,   
         mydwstatway_condsysset.operator,   
         mydwstatway_condsysset.dbname,   
         mydwstatway_condsysset.dbtype,   
         mydwstatway_condsysset.collen,   
         mydwstatway_condsysset.initvalue,   
         mydwstatway_condsysset.sub_keycode  ,
         mydwstatway_condsysset.subsql1 ,
         mydwstatway_condsysset.subsql2 
    from mydwstatway_condsysset  
   where mydwstatway_condsysset.statcode = 'G'  
  

=================================
errordatetime:2004-09-19 12:22:32
user:sa
列名 'out_date' 无效。     DBCode:207
insert into #维修站销售对比分析(spid,insdate,haveupdate,cus_code,cus_name,cus_prov)
 select 1617,'2004-09-19','n',customer.cus_code,customer.cus_name,customer.cus_prov  from  customer  
  
 where   out_date>='2004-07-01' and out_date<'2004-09-20' 
 group by customer.cus_code ,
 customer.cus_name ,
 customer.cus_prov
=================================
errordatetime:2004-09-19 12:22:34
user:sa
     DBCode:0
insert into #维修站销售对比分析(spid,insdate,haveupdate,cus_code,cus_name,cus_prov)
 select 1617,'2004-09-19','n',customer.cus_code,customer.cus_name,customer.cus_prov  from  customer  
  
 where   out_date>='2004-07-01' and out_date<'2004-09-20' 
 group by customer.cus_code ,
 customer.cus_name ,
 customer.cus_prov
=================================
errordatetime:2004-09-19 13:09:17
user:sa
列前缀 'customer' 与查询中所用的表名或别名不匹配。     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 outone.cus_code=customer.cus_code 
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:22
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 outone.cus_code=customer.cus_code 
and outmany.goods_code=goodsno.goo_code

 and  
 (out_date>='2004-07-01'  and out_date<'2004-08-01')