err200409.txt

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

=================================
errordatetime:2004-09-02 11:23:04
user:sa
列名 'totallastnum' 无效。     DBCode:207
update #tt_wholetotalnum  set  totallastnum = 0
=================================
errordatetime:2004-09-02 11:23:40
user:sa
在关键字 'Default' 附近有语法错误。     DBCode:156
Alter Table tt_wholetotalnum Alter Column outsetupnum decimal(18,4)  Default (0)
=================================
errordatetime:2004-09-02 11:23:46
user:sa
在关键字 'Default' 附近有语法错误。     DBCode:156
Alter Table tt_wholetotalnum Alter Column outsetupnum decimal(18,2)  Default (0)
=================================
errordatetime:2004-09-02 11:24:50
user:sa
列名 'totallastnum' 无效。     DBCode:207
update #tt_wholetotalnum  set  totallastnum = 0
=================================
errordatetime:2004-09-02 11:41:51
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_newcheck_ch
datawindow:dw_newcheck_period
语法:  SELECT checkmain.checkid,   
         checkmain.begindate,   
         checkmain.enddate,   
         checkmain.haveend,   
         checkmain.havecalc,   
         checkmain.allcheck,   
         checkmain.period,   
         checkmain.accyear,   
         checkmain.checkbegindate,   
         checkmain.checkenddate,   
         checkmain.stockcode,
         checkmain.isshop 
    FROM checkmain  
where    checkmain.stockcode = '1'
ORDER BY checkmain.period DESC   

=================================
errordatetime:2004-09-02 11:51:26
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 6 in rowfocuschanged event of object dw_stock of w_stocknum_change_morestock..
Window/Menu/Object = w_stocknum_change_morestock.
Error Object/Control = dw_stock.
Script = rowfocuschanged.
Line in Script = 6.
=================================
errordatetime:2004-09-02 11:51:40
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_storagefind_cxo
datawindow:dw_storagefind_cxo
语法:select  goodsno.goo_code ,             sum(stocknum.stocknum) as stocknum ,             goodsno.goo_no ,             goodsno.goo_name ,             goodsno.goo_unit,             goodsno.goo_mate,             goodsno.maxstock,             goodsno.minstock,             upper(goodsno.notproduce) as notproduce,             savestockcode,             goodsnopricetab.wholecostprice,             goodsno.spec,             sum(stocknum.otherstocknum) as otherstocknum,             goodsno.priceretail,               vw_buynogetgoodnum.havenoget,             vw_buygoodallnum.totalbuynum,                     isnull(vw_getorder_goonum.allnosendnum,0) as allnosendnum,             vw_getorder_gooallnum.allnum,             sum(vw_outone_notsend.num) as notsendnum           from  vw_stocknum as stocknum ,vw_getorder_goonum,               goodsno,goodsnopricetab,vw_getorder_gooallnum,               vw_outone_notsend,vw_buynogetgoodnum,vw_buygoodallnum              where  ( goodsno.goo_code = stocknum.goo_code )            and (goodsno.goo_code *= goodsnopricetab.goo_code)          and (goodsno.goo_code *= vw_getorder_goonum.goo_code)          and (goodsno.goo_code *= vw_outone_notsend.goo_code)          and (goodsno.goo_code *= vw_buynogetgoodnum.goo_code)          and (goodsno.goo_code *= vw_getorder_gooallnum.goo_code)          and (goodsno.goo_code *= vw_buygoodallnum.goo_code)           and     (goodsno.visible<>'n')    and ( (goodsno.goo_no like '%94806030%' ))    group by              goodsno.goo_code ,             goodsno.goo_no ,             goodsno.goo_name ,             goodsno.goo_unit,             goodsno.maxstock,             goodsno.notproduce,             goodsno.minstock,             goodsno.goo_mate,             savestockcode,             goodsnopricetab.wholecostprice,             goodsno.spec,             vw_buynogetgoodnum.havenoget,             vw_buygoodallnum.totalbuynum,                 vw_getorder_goonum.allnosendnum,             vw_getorder_gooallnum.allnum,             goodsno.priceretail    
=================================
errordatetime:2004-09-02 11:53:51
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 6 in rowfocuschanged event of object dw_stock of w_stocknum_change_morestock..
Window/Menu/Object = w_stocknum_change_morestock.
Error Object/Control = dw_stock.
Script = rowfocuschanged.
Line in Script = 6.
=================================
errordatetime:2004-09-02 12:04:15
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_stocknum_change_morestock
datawindow:dw_morestock_check_disp
语法:  SELECT store.sto_code,   
         store.sto_name, 
         0.00 as CHECKNUM ,
         stockNum.stocknum,
         '               '  as checkdate,
         store.storetype 
   FROM  store , stocknum
   where store.sto_code*=stocknum.stockcode
      and stocknum.goo_code='25526'

   
 


=================================
errordatetime:2004-09-02 12:04:29
user:sa
程序出错，请与开发人员联系 
Error Number 39.
Error text = Error accessing external object property sto_code at line 6 in rowfocuschanged event of object dw_stock of w_stocknum_change_morestock..
Window/Menu/Object = w_stocknum_change_morestock.
Error Object/Control = dw_stock.
Script = rowfocuschanged.
Line in Script = 6.
=================================
errordatetime:2004-09-02 12:05:48
user:sa
第7个SQL
列名 'isinp' 无效。
insert into #tt_stockNum_change(haveok,itemName,spid,goo_code,changedate,Innum,billNo,customerName,inputman,stockcode)  Select isnull(movemain.isinp,'N'),'调入仓',1572,movemany.goo_code,movemain.move_date, movemany.num,movemain.move_no,movemain.tostock,movemain.human,movemain.tostock  from movemain,movemany  where movemain.move_no = movemany.move_no  and movemain.move_date >='2004-06-27 18:30:20' and movemain.move_date <'2004-09-03 00:00:00' and movemany.goo_code='25526' and tostock in ('1')
=================================
errordatetime:2004-09-02 12:07:40
user:sa
第8个SQL
列名 'isok' 无效。
insert into #tt_stockNum_change(haveok,itemName,spid,goo_code,changedate,outnum,billNo,customerName,inputman,stockcode)  Select isnull(movemain.isok,'N'),'调出仓',1572,movemany.goo_code,movemain.move_date, movemany.num,movemain.move_no,movemain.fromstock,movemain.human,movemain.fromstock  from movemain,movemany  where movemain.move_no = movemany.move_no  and movemain.move_date >='2004-06-27 18:30:20' and movemain.move_date <'2004-09-03 00:00:00' and movemany.goo_code='25526' and fromstock in ('1')
=================================
errordatetime:2004-09-02 12:08:42
user:sa
第8个SQL
列名 'isok' 无效。
insert into #tt_stockNum_change(haveok,itemName,spid,goo_code,changedate,outnum,billNo,customerName,inputman,stockcode)  Select isnull(movemain.isok,'N'),'调出仓',1572,movemany.goo_code,movemain.move_date, movemany.num,movemain.move_no,movemain.fromstock,movemain.human,movemain.fromstock  from movemain,movemany  where movemain.move_no = movemany.move_no  and movemain.move_date >='2004-06-27 18:30:20' and movemain.move_date <'2004-09-03 00:00:00' and movemany.goo_code='25526' and fromstock in ('1')
=================================
errordatetime:2004-09-02 12:10:10
user:sa
仅当使用了列的列表，并且 IDENTITY_INSERT 为 ON 时，才能在表 'tt_stockNum_change' 中为标识列指定显式值。     DBCode:8101
=================================
errordatetime:2004-09-02 12:10:36
user:sa
仅当使用了列的列表，并且 IDENTITY_INSERT 为 ON 时，才能在表 'tt_stockNum_change' 中为标识列指定显式值。     DBCode:8101
=================================
errordatetime:2004-09-02 13:09:17
user:sa
列名 'totallastnum' 无效。     DBCode:207
update #tt_wholetotalnum  set  totallastnum = 0
=================================
errordatetime:2004-09-02 13:45:50
user:sa
列名 'totallastnum' 无效。     DBCode:207
update #tt_wholetotalnum  set  totallastnum = 0
=================================
errordatetime:2004-09-02 15:13:22
user:sa
列名 'totalfirstnum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:14:00
user:sa
列名 'salegetmaternum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:14:48
user:sa
列名 'salegetmaternum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:15:17
user:sa
列名 'othergetmaternum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:15:42
user:sa
列名 'othergetmaternum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:16:01
user:sa
列名 'costprice' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:16:25
user:sa
列名 'produceNum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:16:51
user:sa
列名 'bomuseNum' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:17:15
user:sa
列名 'factrate' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:17:37
user:sa
列名 'haveupdate' 无效。     DBCode:207
备份数据
=================================
errordatetime:2004-09-02 15:18:00
user:sa
列名 'lastprice' 无效。     DBCode:207
更新价格
=================================
errordatetime:2004-09-02 15:18:24
user:sa
对象名 'periodgoodcostprice' 无效。     DBCode:208
更新进仓价格
=================================
errordatetime:2004-09-04 09:45:38
user:sa
列名 'totallastnum' 无效。     DBCode:207
update #tt_wholetotalnum  set  totallastnum = 0
=================================
errordatetime:2004-09-10 13:44:31
user:sa
程序出错，请与开发人员联系 
Error Number 30.
Error text = Cannot find data type cb_twocheck at line 11 in create event of object w_input_find..
Window/Menu/Object = w_input_find.
Error Object/Control = w_input_find.
Script = create.
Line in Script = 11.
=================================
errordatetime:2004-09-10 13:45:12
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_salebill_query_dyb_otherdb_tosale 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-10 13:45:59
user:sa
程序出错，请与开发人员联系 
Error Number 30.
Error text = Cannot find data type cb_twocheck at line 11 in create event of object w_input_find..
Window/Menu/Object = w_input_find.
Error Object/Control = w_input_find.
Script = create.
Line in Script = 11.
=================================
errordatetime:2004-09-10 13:48:52
user:sa
程序出错，请与开发人员联系 
Error Number 30.
Error text = Cannot find data type cb_twocheck at line 11 in create event of object w_input_find..
Window/Menu/Object = w_input_find.
Error Object/Control = w_input_find.
Script = create.
Line in Script = 11.
=================================
errordatetime:2004-09-10 13:50:17
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_sellbill_query_dyb 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-10 13:50:48
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_salebill_query_dyb_otherdb_tosale 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-10 13:51:25
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_sellbill_query_dyb 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-14 09:32:27
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_sellbill_query_cxo 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-14 09:33:07
user:sa
程序出错，请与开发人员联系 
Error Number 22.
Error text = Unknown object type: w_sellbill_query_cxo 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-14 14:58:04
user:sa
程序出错，请与开发人员联系 
Error Number 30.
Error text = Cannot find data type cb_twocheck at line 11 in create event of object w_input_find..
Window/Menu/Object = w_input_find.
Error Object/Control = w_input_find.
Script = create.
Line in Script = 11.
=================================
errordatetime:2004-09-14 16:50:38
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 16:51:17
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 16:51:22
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 16:51:34
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 16:52:11
user:sa