err200407.txt

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

errordatetime:2004-07-09 10:49:13
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '25947'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:49:13
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '25499'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:49:14
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '5131'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:49:15
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '26731'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:49:15
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '26529'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:49:16
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_all.goo_code)
        and stockNum.stockcode = '1'
        and goodsno.goo_code = '21232'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================
errordatetime:2004-07-09 10:54:31
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 (stocknum>0)    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-09 10:54:36
user:sa

=================================
errordatetime:2004-07-09 10:54:59
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')    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-10 17:39:55
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
无法将 NULL 值插入列 'adddate'，表 'casio.dbo.shiptodate'；该列不允许空值。INSERT 失败。

No changes made to database.

INSERT INTO shiptodate ( ship ) VALUES ( 'Allocated' )

出错对象:n_tr
父对象:w_ship_notodate
datawindow:dw_shiptodate
语法:INSERT INTO shiptodate ( ship ) VALUES ( 'Allocated' )
=================================
errordatetime:2004-07-10 18:32:36
user:sa
出错对象:dw_good
父对象:w_goodtype
dataobject：dw_goods_ch
请检查include.ini配制是否正确!
=================================
errordatetime:2004-07-10 18:32:41
user:sa
出错对象:dw_result
父对象:w_goodfind
dataobject：dw_goods_ch
请检查include.ini配制是否正确!
=================================
errordatetime:2004-07-11 15:56:20
user:sa
根据
出错Transaction not connected
对象n_ds
=================================
errordatetime:2004-07-11 16:49:49