err200407.txt

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

=================================
errordatetime:2004-07-01 14:22:44
user:sa
程序出错，请与开发人员联系 
Error Number 21.
Error text = Bad runtime function reference at line 17 in function vf_setdw of object w_sellbill_query..
Window/Menu/Object = w_sellbill_query.
Error Object/Control = w_sellbill_query.
Script = vf_setdw.
Line in Script = 17.
=================================
errordatetime:2004-07-02 15:53:51
user:sa
程序出错，请与开发人员联系 
Error Number 21.
Error text = Bad runtime function reference at line 1 in open event of object w_sellbill_query_dyb..
Window/Menu/Object = w_sellbill_query_dyb.
Error Object/Control = w_sellbill_query_dyb.
Script = open.
Line in Script = 1.
=================================
errordatetime:2004-07-02 16:22:13
user:sa
程序出错，请与开发人员联系 
Error Number 21.
Error text = Bad runtime function reference at line 18 in open event of object w_buyorder_query_dyb..
Window/Menu/Object = w_buyorder_query_dyb.
Error Object/Control = w_buyorder_query_dyb.
Script = open.
Line in Script = 18.
=================================
errordatetime:2004-07-02 16:31:38
user:sa
程序出错，请与开发人员联系 
Error Number 21.
Error text = Bad runtime function reference at line 18 in open event of object w_buyorder_query_dyb..
Window/Menu/Object = w_buyorder_query_dyb.
Error Object/Control = w_buyorder_query_dyb.
Script = open.
Line in Script = 18.
=================================
errordatetime:2004-07-02 17:48:28
user:sa
违反了 PRIMARY KEY 约束 'PK_goodsno'。不能在对象 'goodsno' 中插入重复键。     DBCode:2627
insert into goodsno(goo_code,goo_name,goo_no,spec,visible,goo_weight,pricetype,goo_type) select  left(convert(char(8),Id),1)+'S'+substring(goo_no,3,5),goo_name,goo_no,spec,visible,weight,pricetype,goo_type from tt_import_goods  where goo_no not in (select goo_no from goodsno)
=================================
errordatetime:2004-07-02 17:56:33
user:sa
程序出错，请与开发人员联系 
Error Number 21.
Error text = Bad runtime function reference at line 4 in open event of object w_goods_find_cxo..
Window/Menu/Object = w_goods_find_cxo.
Error Object/Control = w_goods_find_cxo.
Script = open.
Line in Script = 4.
=================================
errordatetime:2004-07-06 16:35:51
user:sa
程序出错，请与开发人员联系 
Error Number 7.
Error text = Unresolvable external setfont when linking reference at line 1 in constructor event of object uo_toolbar..
Window/Menu/Object = uo_toolbar.
Error Object/Control = uo_toolbar.
Script = constructor.
Line in Script = 1.
=================================
errordatetime:2004-07-07 00:10:58
user:sa
数据库中已存在名为 'mydwNewmain' 的对象。     DBCode:2714
 create table dbo.mydwNewmain  (dwNo char(10) not NULL  ,  dwDate datetime Null  , human char(20) Null  , memo varchar(250) Null  , pbl varchar(250) Null  , dwName varchar(250) Null  , syntax image Null   constraint PK__mydwNewmain Primary Key(dwNo) ) 
=================================
errordatetime:2004-07-07 00:14:04
user:sa
程序出错，请与开发人员联系 
Error Number 7.
Error text = Unresolvable external setfont when linking reference at line 34 in open event of object w_dwprop..
Window/Menu/Object = w_dwprop.
Error Object/Control = w_dwprop.
Script = open.
Line in Script = 34.
=================================
errordatetime:2004-07-07 11:28:08
user:sa
无法打开备份设备 'd:\backupdb\casio200407071128'。设备出现错误或设备脱机。详细信息请参阅 SQL Server 错误日志。     DBCode:3201
=================================
errordatetime:2004-07-07 12:17:17
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象: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_getorder_goonum.allnum,             isnull(vw_getorder_goonum.allnosendnum,0) as allnosendnum,             sum(vw_outone_notsend.num) as notsendnum           from  stocknum ,vw_getorder_goonum,               goodsno,goodsnopricetab,               vw_outone_notsend              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.visible<>'n')    and ( exists ( select * from goodtypestat as gs  where gs.typeno=goodsno.goo_type and parentno= '73b'))    and (goo_type  like '73b%' )    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_getorder_goonum.allnum,             vw_getorder_goonum.allnosendnum,             goodsno.priceretail    
=================================
errordatetime:2004-07-08 16:16:48
user:sa
数据库发生错误.


错误代码:  208

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

错误行数: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_all.allnum,
           vw_getorder_goonum_all.allnosendnum
        FROM stockNum ,vw_getorder_goonum_all,
             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 = '100015'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-08 16:16:51
user:sa
数据库发生错误.


错误代码:  208

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

错误行数: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_all.allnum,
           vw_getorder_goonum_all.allnosendnum
        FROM stockNum ,vw_getorder_goonum_all,
             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 = '1007'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-08 16:17:43
user:sa
数据库发生错误.


错误代码:  107

错误信息:
Select error: 列前缀 'vw_getorder_goonum' 与查询中所用的表名或别名不匹配。

错误行数: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_all.allnum,
           vw_getorder_goonum_all.allnosendnum
        FROM stockNum ,vw_getorder_goonum_all,
             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 = '100015'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-08 16:18:14
user:sa
数据库发生错误.


错误代码:  107

错误信息:
Select error: 列前缀 'vw_getorder_goonum' 与查询中所用的表名或别名不匹配。

错误行数: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_all.allnum,
           vw_getorder_goonum_all.allnosendnum
        FROM stockNum ,vw_getorder_goonum_all,
             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 = '1007'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-08 16:22:03
user:sa

=================================
errordatetime:2004-07-08 16:22:08
user:sa

=================================
errordatetime:2004-07-08 16:22:14
user:sa

=================================
errordatetime:2004-07-08 16:22:22
user:sa

=================================
errordatetime:2004-07-08 16:23:03
user:sa

=================================
errordatetime:2004-07-08 16:23:50
user:sa

=================================
errordatetime:2004-07-08 16:23:55
user:sa

=================================
errordatetime:2004-07-09 10:48:54
user:sa
数据库发生错误.


错误代码:  208