err190001.txt

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

Select error: 数据转换发生溢出。

出错对象:n_tr
父对象:w_printpreview
datawindow:dw_buy_print_main_dyb
语法:  SELECT  settlekind.settlekind ,           settlekind.settle     FROM settlekind    
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发.dataserver jxcnew


错误号:  2

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

出错对象:dw_print
父对象:w_printpreview
datawindow:dw_buy_print_main_dyb
语法:  SELECT  settlekind.settlekind ,           settlekind.settle     FROM settlekind    
=================================
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:
登录不正确。     DBCode:10003
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_cus_find
datawindow:dw_customer_manager
语法:select  customer.cus_code ,             customer.cus_name ,             customer.cus_prov ,             customer.cus_city ,             customer.delaydate ,              customer.allname,             customer.memo ,             customer.phone ,             customer.address ,             customer.fax ,             customer.e_mail ,             customer.trade ,             customer.kind ,             customer.nomoneycansend ,             customer.isend ,             customer.iscustomer ,             customer.issupplyer ,             customer.settlekind ,             customer.arrivedate ,             customer.allname,                  customer.custype,             customer.mobile,             customer.postcode,             linkman,             visible,             ' ' as  seleced,             trafficeaddr            from  customer
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_move_find_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







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


错误号:  2

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

出错对象:dw_good
父对象:w_move_find_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







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


错误号:  2

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

出错对象:dw_good
父对象:w_move_find_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







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


错误号:  0

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

出错对象:n_tr
父对象:w_movestock_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







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


错误号:  0

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

出错对象:n_tr
父对象:w_move_find_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







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


错误号:  2

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

出错对象:dw_good
父对象:w_move_find_dyb
datawindow:dw_move_detail
语法:  SELECT movemany.move_no,   
         movemany.goo_code,   
         movemany.num,   
         movemany.Memo,   
         movemany.moveId  ,
         goodsno.goo_name ,
         goodsno.goo_no,
         goodsno.goo_unit,
         goodsno.spec
    FROM movemany   , 
               goodsno
    where moveMany.goo_code= goodsno.goo_code
    and    moveMany.move_no = '04080002'







=================================
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:
无法连接: SQL Server 不可用或不存在。 无法连接: SQL Server 不存在或拒绝网络访问。     DBCode:10004
=================================
errordatetime:1900-01-01 00:00:00
user:
无法连接: SQL Server 不可用或不存在。 无法连接: SQL Server 不存在或拒绝网络访问。     DBCode:10004
=================================
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
数据库类型MSS Microsoft SQL Server 6.x
数据库名casio_bak
服务器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_monthcheck_ch
datawindow:dw_monthcheck_ip
语法:select     goodsno.goo_code ,             goodsno.goo_name ,             goodsno.goo_unit ,             goodsno.goo_type ,             goodsno.goo_price ,             goodsno.saleprice ,             goodsno.inprice ,             goodsno.goo_mate ,             goodsno.maxstock ,             goodsno.minstock ,             goodsno.costprice ,             goodsno.content,             goodsno.goo_no ,             goodsno.source,             savestockcode,             salememo,             goodsno.spec,             visible,             checkgoods.checknum,             checkgoods.checkno,             checkprice,             checkgoods.checkgoodsid,             (stocknumback.stocknum) as backstocknum,             '       '  as sort,             stocknum.stocknum          from  goodsno ,              checkgoods,              stocknumback,              stocknum           where  goodsno.goo_code *= checkgoods.goo_code        and goodsno.goo_code *= stocknumback.goo_code        and goodsno.goo_code *= stocknum.goo_code        and  goodsno.visible = 'y'            and     (visible<>'n')    and (stocknum.stockcode ='1')    and (checkgoods.checkno ='200406' and checkgoods.stock ='1' and stocknumback.period='200406' and stocknumback.stockcode ='1')
=================================
errordatetime:1900-01-01 00:00:00
user:sa
一个数据库错误已经被触发. 


错误号:  0

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

出错对象:n_tr
父对象:w_all_num_data_ch_jc
datawindow:dw_inp_out_total_detail_ch_jc
语法:  SELECT tt_wholetotalnum.inputnum,  /*正常进仓*/
         tt_wholetotalnum.secondinpnum,   /*返工进仓*/
         tt_wholetotalnum.outnum,    /*正常销售*/
         tt_wholetotalnum.goo_code,   
         tt_wholetotalnum.cusbacknum,  /*客户退货*/  
         tt_wholetotalnum.getmaternum,   /*其他领料*/
         tt_wholetotalnum.givenum,      /*赠品发货*/
         tt_wholetotalnum.profilenum,     /*损益数*/
         tt_wholetotalnum.laststocknum,    /*上期库存*/
         tt_wholetotalnum.spid,         
         tt_wholetotalnum.checknum,        /*当前库存数*/
         tt_wholetotalnum.moveinnum,        /*转入仓数*/
         tt_wholetotalnum.moveoutnum,       /*转出仓数*/
         tt_wholetotalnum.stockcode,
         tt_wholetotalnum.xzgetmaternum,     /*行政领料*/
         tt_wholetotalnum.samplegetmaternum,       /*抽检领料*/
         tt_wholetotalnum.secondgetmaternum,         /*返工领料*/
         tt_wholetotalnum.doublegetmaternum,        /*孖装领用*/
         tt_wholetotalnum.totallastnum,         /*帐面结存数*/
         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,
         goodsno,
         goodtype
where    tt_wholetotalnum.goo_code = goodsno.goo_code
and      goodsno.goo_type *=goodtype.typeno  
and      tt_wholetotalnum.spid = 1540