err190001.txt

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

=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='2')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='1')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='2')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='3')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='2')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectgoods
datawindow:dddw_goods_stock
语法:select  goodsno.goo_code ,             goodsno.goo_name +'      '+content as goo_name,             goodsno.goo_no ,             goodsno.inprice ,             goodsno.goo_unit ,             vw_stocknum.stocknum ,             goodsno.goo_mate,             goodsno.goo_price,             goodsno.goo_place,             saleprice,             salememo ,             content,             spec           from  goodsno ,               stocknum as vw_stocknum                   where  ( goodsno.goo_code *= vw_stocknum.goo_code)   and                 visible='y'           and     (vw_stocknum.stockcode='3')  order by  goodsno.goo_code asc              
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_all_num_data_ch_jc
datawindow:dw_inout_total_ch_jc
语法:  SELECT goodsno.goo_code,          
         sum(isnull(tt1.inputnum,0)+isnull(tt1.cusbacknum,0)+isnull(tt1.moveinnum,0)+isnull(tt1.secondinpnum,0)+isnull(tt1.profilenum,0)+isnull(tt1.backmaternum,0)) as thisinmoney,
         sum(isnull(tt2.inputnum,0)+isnull(tt2.cusbacknum,0)+isnull(tt2.moveinnum,0)+isnull(tt2.secondinpnum,0)+isnull(tt2.profilenum,0)+isnull(tt2.backmaternum,0)) as thisinnum,
         sum(isnull(tt1.outnum,0)+isnull(tt1.givenum,0)+isnull(tt1.moveoutnum,0)+isnull(tt1.xzgetmaternum,0)+isnull(tt1.salegetmaternum,0)+isnull(tt1.samplegetmaternum,0)+isnull(tt1.secondgetmaternum,0)+isnull(tt1.doublegetmaternum,0)+isnull(tt1.getmaternum,0)+isnull(tt1.othergetmaternum,0)+isnull(tt1.backtoshopnum,0)) as thisoutmoney,
         sum(isnull(tt2.outnum,0)+isnull(tt2.givenum,0)+isnull(tt2.moveoutnum,0)+isnull(tt2.xzgetmaternum,0)+isnull(tt2.salegetmaternum,0)+isnull(tt2.samplegetmaternum,0)+isnull(tt2.secondgetmaternum,0)+isnull(tt2.doublegetmaternum,0)+isnull(tt2.getmaternum,0)+isnull(tt2.othergetmaternum,0)+isnull(tt2.backtoshopnum,0)) as thisoutnum,         
         sum(isnull(tt1.laststocknum,0)) as laststockmoney,
         sum(isnull(tt2.laststocknum,0)) as laststocknum,
         goodsno.goo_no,
         goodsno.goo_name,
         goodsno.inprice,
         goodsno.content,
         goodsno.spec,
         goodsno.goo_unit,
         goodsno.goo_type,
         upper(goodtype.parentno) as parentno,
         '         ' as getmater1,
         '          ' as getmater2 ,
         0.00  as resetstocknum 
    FROM tt_wholetotalnum as tt1,tt_wholetotalnumbak as tt2,
         goodsno,
         goodtype
where    tt1.goo_code = goodsno.goo_code
and      goodsno.goo_type *=goodtype.typeno  
and      tt1.spid = 1579
and tt1.spid = 1579
and tt1.goo_code = tt2.goo_code
group by goodsno.goo_no,
         goodsno.goo_name,
         goodsno.inprice,
         goodsno.content,
         goodsno.spec,
         goodsno.goo_unit,
         goodsno.goo_type,
         goodsno.goo_code,
         goodtype.typeno,
         goodtype.parentno
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectcustomer
datawindow:dw_customer_grid
语法:  SELECT cus_code,                 cus_name,               isCustomer,             isSupplyer,             custype,             '      ' as helpcode      FROM vw_customer         
=================================
errordatetime:1900-01-01 00:00:00
user:
错误信息A SQLServer request resulted in a bad return code or status but no error message was returned
数据库类型MSS Microsoft SQL Server 6.x
数据库名casio0907
服务器casio-server
SQL状态-1
错误号999      
用户名sa
=================================
errordatetime:1900-01-01 00:00:00
user:
Transaction not connected     DBCode:0
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_brand_de
datawindow:dw_brand
语法:  SELECT brand.brandId,              brand.brandName,              brand.PackText,              brand.BarText        FROM brand      
=================================
errordatetime:1900-01-01 00:00:00
user:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_selectcustomer
datawindow:dw_customer_grid_help
语法:  SELECT cus_code,                 cus_name,               isCustomer,             isSupplyer,             custype,             '      ' as helpcode      FROM vw_customer         
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_printpreview
datawindow:dw_print_billoflading
语法: SELECT g.goo_code,
         g.goo_name as goo_name,   
         om.Dispprice,  
         om.nodis_price,  
         om.PRICE,
         sum(om.num) as num,
         g.goo_no as goo_no,
         goo_unit,
         om.discount,
         g.spec,
         g.goo_mate,
         om.piece,
         g.content,
         g.savestockcode
    FROM outmany as om,
         goodsno as g 
    where om.goods_code*=g.goo_code
      and om.out_no='XS04090249'     
    group by g.goo_code,
          om.goo_name,g.goo_name ,   
         om.Dispprice,  
         om.nodis_price,  
         om.discount,
         om.PRICE,
         om.goo_no,g.goo_no ,
         goo_unit,
         g.spec,
         g.goo_mate,
         om.piece,
         g.content,
         g.savestockcode




=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_brand_de
datawindow:dw_brand
语法:  SELECT brand.brandId,              brand.brandName,              brand.PackText,              brand.BarText        FROM brand      
=================================
errordatetime:1900-01-01 00:00:00
user:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: Decimal conversion error.  PowerBuilder only supports 18 decimal digits.

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.num1  ,tt.money1  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #客户订单类别分析 as tt   order by  goo_type
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: Decimal conversion error.  PowerBuilder only supports 18 decimal digits.

出错对象:n_tr
父对象:w_dw_report_base
datawindow:
语法:select tt.goo_type1  ,tt.goo_type  ,tt.pricetype  ,tt.num1  ,tt.money1  ,tt.num2  ,tt.money2  ,tt.num3  ,tt.money3  ,tt.spid  ,tt.insdate  ,tt.haveupdate     from  #客户订单类别分析 as tt   order by  goo_type
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_brand_de
datawindow:dw_brand
语法:  SELECT brand.brandId,              brand.brandName,              brand.PackText,              brand.BarText        FROM brand      
=================================
errordatetime:1900-01-01 00:00:00
user:
A SQLServer request resulted in a bad return code or status but no error message was returned     DBCode:999
=================================
errordatetime:1900-01-01 00:00:00
user:
A SQLServer request resulted in a bad return code or status but no error message was returned     DBCode:999
=================================
errordatetime:1900-01-01 00:00:00
user:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_mysysset_all
datawindow:dw_mysysset_itemtype
语法:  SELECT  mysysset.itemName ,           mysysset.ItemType ,           mysysset.Itemvalue ,           mysysset.Memo     FROM mysysset      WHERE ( mysysset.ItemType = '业务部' )