err200407.txt

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

             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 = '26779'
        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:05
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 = '36675'
        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:06
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 = '39101'
        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:06
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 = '28268'
        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:07
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 = '28698'
        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:07
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 = '25982'
        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:08
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 = '41207'
        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:09
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 = '1216'
        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:12
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 = '27108'
        group by
          goodsno.goo_code ,
          goodsno.goo_no,
          stocknum.otherstocknum,
          vw_getorder_goonum_all.allnum,
          vw_getorder_goonum_all.allnosendnum
=================================