err200408.txt

delphi编写的ERP原代码事例２,供广大初学者学习参考!

Line in Script = 9.
=================================
errordatetime:2004-08-13 12:57:53
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象: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_buynogetgoodnum.totalbuynum,                     isnull(vw_getorder_goonum.allnosendnum,0) as allnosendnum,             vw_getorder_gooallnum.allnum,             sum(vw_outone_notsend.num) as notsendnum           from  stocknum ,vw_getorder_goonum,               goodsno,goodsnopricetab,vw_getorder_gooallnum,               vw_outone_notsend,vw_buynogetgoodnum              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.visible<>'n')    and ( (goodsno.goo_no like '%27651575%' ))    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_buynogetgoodnum.totalbuynum,                 vw_getorder_goonum.allnosendnum,             vw_getorder_gooallnum.allnum,             goodsno.priceretail    
=================================
errordatetime:2004-08-13 14:35:28
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 61 in pfe_dealwithstocknum event of object w_movestock..
Window/Menu/Object = w_movestock.
Error Object/Control = w_movestock.
Script = pfe_dealwithstocknum.
Line in Script = 61.
=================================
errordatetime:2004-08-13 14:36:30
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 137 in pfe_dealwithstocknum event of object w_movestock_dyb..
Window/Menu/Object = w_movestock_dyb.
Error Object/Control = w_movestock_dyb.
Script = pfe_dealwithstocknum.
Line in Script = 137.
=================================
errordatetime:2004-08-13 14:37:47
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 61 in pfe_dealwithstocknum event of object w_movestock..
Window/Menu/Object = w_movestock.
Error Object/Control = w_movestock.
Script = pfe_dealwithstocknum.
Line in Script = 61.
=================================
errordatetime:2004-08-13 14:38:31
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 61 in pfe_dealwithstocknum event of object w_movestock..
Window/Menu/Object = w_movestock.
Error Object/Control = w_movestock.
Script = pfe_dealwithstocknum.
Line in Script = 61.
=================================
errordatetime:2004-08-13 14:40:48
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 137 in pfe_dealwithstocknum event of object w_movestock_dyb..
Window/Menu/Object = w_movestock_dyb.
Error Object/Control = w_movestock_dyb.
Script = pfe_dealwithstocknum.
Line in Script = 137.
=================================
errordatetime:2004-08-13 14:41:55
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 137 in pfe_dealwithstocknum event of object w_movestock_dyb..
Window/Menu/Object = w_movestock_dyb.
Error Object/Control = w_movestock_dyb.
Script = pfe_dealwithstocknum.
Line in Script = 137.
=================================
errordatetime:2004-08-13 14:48:45
user:sa
程序出错，请与开发人员联系 
Error Number 6.
Error text = Invalid DataWindow row/column specified at line 26 in pfc_preupdate event of object w_movestock_dyb..
Window/Menu/Object = w_movestock_dyb.
Error Object/Control = w_movestock_dyb.
Script = pfc_preupdate.
Line in Script = 26.
=================================
errordatetime:2004-08-13 14:58:15
user:sa
数据库发生错误.


错误代码:  207

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

错误行数:0
n_ds 错误Dataobject:dw_storagefind_cxo_bak
错误的SQL:   SELECT  goodsno.goo_code ,
           goodsno.goo_no,
           sum(stockNum.stocknum) as stocknum ,
           stocknum.otherstocknum,
           vw_getorder_goonum.allnum,
           vw_getorder_goonum.allnosendnum
        FROM stockNum ,vw_getorder_goonum,
             goodsno
        WHERE ( goodsno.goo_code= stockNum.goo_code )  
        and (goodsno.goo_code *= vw_getorder_goonum.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '7481'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum.allnum,
          vw_getorder_goonum.allnosendnum
=================================
errordatetime:2004-08-14 10:47:21
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_repaircode_query
datawindow:dw_repaircode_detail
语法:select repair_main.repairno,              repair_main.mainno,              repair_main.detailno,                     repair_main.model,              repair_main.status,              repair_main.camerano,              repair_main.month,              repair_main.insdate,              repair_main.human,              repair_main.checkbegindate,              repair_main.checkenddate,              repair_main.checkman,              repair_main.tat1,              repair_main.repairbegindate,              repair_main.repairenddate,              repair_main.repairman,              repair_main.tat2,              repair_main.backdate,              repair_main.backman,              repair_main.tat3,             repair_main.cus_code,           customer.cus_name,            repair_main.area,              repair_main.user_name,              repair_main.user_tel,              repair_main.selfno,              repair_main.repairtype,              repair_main.symptom,              repair_main.serversmoney,              repair_main.financecheck,              repair_main.financecheckman,              repair_main.financecheckdate,              repair_main.havegetfinance,              repair_main.s2,              repair_main.condition,              repair_main.senddate,              repair_main.rechiveddate,              repair_main.memo,           repair_main.selfno2         from  repair_main,customer      where  repair_main.cus_code *= customer.cus_code             and     (repair_main.insdate>='2001-01-01' and repair_main.insdate<'2004-08-15')
=================================
errordatetime:2004-08-18 14:43:19
user:sa
程序出错，请与开发人员联系 
Error Number 36.
Error text = Name not found accessing external object property invioceno at line 2 in clicked event of object pb_save of w_invoice_input..
Window/Menu/Object = w_invoice_input.
Error Object/Control = pb_save.
Script = clicked.
Line in Script = 2.
=================================
errordatetime:2004-08-18 14:58:28
user:sa
程序出错，请与开发人员联系 
Error Number 39.
Error text = Error accessing external object property invoiceno at line 12 in clicked event of object pb_save of w_invoice_input..
Window/Menu/Object = w_invoice_input.
Error Object/Control = pb_save.
Script = clicked.
Line in Script = 12.
=================================
errordatetime:2004-08-18 15:00:40
user:sa
程序出错，请与开发人员联系 
Error Number 39.
Error text = Error accessing external object property invoiceno at line 12 in clicked event of object pb_save of w_invoice_input..
Window/Menu/Object = w_invoice_input.
Error Object/Control = pb_save.
Script = clicked.
Line in Script = 12.
=================================
errordatetime:2004-08-18 15:08:45
user:sa
程序出错，请与开发人员联系 
Error Number 36.
Error text = Name not found accessing external object property haveinvoiceno at line 13 in clicked event of object pb_save of w_invoice_input..
Window/Menu/Object = w_invoice_input.
Error Object/Control = pb_save.
Script = clicked.
Line in Script = 13.
=================================
errordatetime:2004-08-18 17:48:21
user:sa
程序出错，请与开发人员联系 
Error Number 18.
Error text = Function doesn't return value at line 9 in function vf_checkgoodexit of object w_checkrepair_query..
Window/Menu/Object = w_checkrepair_query.
Error Object/Control = w_checkrepair_query.
Script = vf_checkgoodexit.
Line in Script = 9.
=================================
errordatetime:2004-08-19 10:13:58
user:sa
列名 'blno' 无效。     DBCode:207
=================================
errordatetime:2004-08-19 10:33:48
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_packbuy_goods_query_last_dyb
datawindow:dw_packbuy_detail_good_query_cxo
语法:select     goodsno.goo_name ,             goodsno.goo_unit ,             goodsno.goo_type ,             goodsno.spec ,             goodsno.goo_mate,             goodsno.goo_no ,             goodsno.content ,             customer.cus_name ,             buymain.buyno ,             buymain.arrivedate ,             buymain.oneurgencydate ,             buymain.haveout ,             buymain.selfno,             buymain.haveend ,             buymain.supplyno ,             buymain.buydate ,             buydetail.price ,             buydetail.quanty ,             buydetail.dis,             buydetail.haveend ,             buydetail.haveinnum ,             buydetail.haveget ,             buydetail.memo ,             buydetail.goo_code,             buydetail.goo_code,             buydetail.allcoation_schedule,             buydetail.havelogongetorder,             buydetail.confirmnum,             buydetail.cancelnum,             buydetail.comedate,             buydetail.confirmstate,              buymain.stockcode,             buydetail.invoiceno,             buydetail.blno,             buydetail.bldate,             '  ' as selected                 from   buydetail ,             buymain ,             goodsno ,             customer                       where   ( buydetail.buyno = buymain.buyno ) and                         ( buydetail.goo_code = goodsno.goo_code ) and                         ( buymain.supplyno = customer.cus_code )      and     (buymain.buydate<'2004-08-20' and  (goodsno.goo_no like '%10128736%' ) and buymain.buydate>='2001-01-01')
=================================
errordatetime:2004-08-19 11:17:15
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 230 in clicked event of object pb_save of w_import_buyallcoation..
Window/Menu/Object = w_import_buyallcoation.
Error Object/Control = pb_save.
Script = clicked.
Line in Script = 230.
=================================
errordatetime:2004-08-26 16:34:37
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_group_user_set_add
datawindow:dw_pwset_user
语法:  SELECT  myuser.uid ,           myuser.userName ,           myuser.gid ,           myuser.notdelete ,           myuser.notload ,           myuser.notmodify ,           myuser.notmodifyother ,           myuser.canmodifydays     FROM myuser      WHERE ( myuser.gid = 2 )  ORDER BY myuser.uid          ASC  
=================================
errordatetime:2004-08-26 16:35:07
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_group_user_set_add
datawindow:dw_pwset_user
语法:  SELECT  myuser.uid ,           myuser.userName ,           myuser.gid ,           myuser.notdelete ,           myuser.notload ,           myuser.notmodify ,           myuser.notmodifyother ,           myuser.canmodifydays     FROM myuser      WHERE ( myuser.gid = 2 )  ORDER BY myuser.uid          ASC  
=================================
errordatetime:2004-08-26 16:35:08
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_group_user_set_add
datawindow:dw_pwset_user
语法:  SELECT  myuser.uid ,           myuser.userName ,           myuser.gid ,           myuser.notdelete ,           myuser.notload ,           myuser.notmodify ,           myuser.notmodifyother ,           myuser.canmodifydays     FROM myuser      WHERE ( myuser.gid = 2 )  ORDER BY myuser.uid          ASC  
=================================
errordatetime:2004-08-26 16:35:13
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_group_user_set_add
datawindow:dw_pwset_user
语法:  SELECT  myuser.uid ,           myuser.userName ,           myuser.gid ,           myuser.notdelete ,           myuser.notload ,           myuser.notmodify ,           myuser.notmodifyother ,           myuser.canmodifydays     FROM myuser      WHERE ( myuser.gid = 3 )  ORDER BY myuser.uid          ASC