err200405.txt

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

=================================
errordatetime:2004-05-18 17:48:21
user:sa
程序出错，请与开发人员联系 
Error Number 2.
Error text = Null object reference at line 21 in function of_rowselectsingle of object n_cst_dwsrv_rowselection..
Window/Menu/Object = n_cst_dwsrv_rowselection.
Error Object/Control = n_cst_dwsrv_rowselection.
Script = of_rowselectsingle.
Line in Script = 21.
=================================
errordatetime:2004-05-19 17:53:35
user:sa
第 1 行: 'goo_name' 附近有语法错误。     DBCode:170
 update goodsno  goo_name=tt.goo_name,spec=tt.spec,visible=tt.visible, goo_weight=tt.goo_weight,pricetype=tt.pricetype from tt_import_goods as tt  where tt.goo_no=goodsno.goo_no 
=================================
errordatetime:2004-05-19 17:54:03
user:sa
列名 'goo_weight' 无效。     DBCode:207
 update goodsno set  goo_name=tt.goo_name,spec=tt.spec,visible=tt.visible, goo_weight=tt.goo_weight,pricetype=tt.pricetype from tt_import_goods as tt  where tt.goo_no=goodsno.goo_no 
=================================
errordatetime:2004-05-19 17:55:01
user:sa
在关键字 'select' 附近有语法错误。     DBCode:156
insert into goodsno(goo_code,goo_name,goo_no,spec,visible,goo_weight,pricetype select  'I'+Id,goo_name,goo_no,spec,visible,goo_weight,pricetype from tt_import_goods  where goo_no not in (select goo_no from goodsno)
=================================
errordatetime:2004-05-19 17:55:37
user:sa
列名 'goo_weight' 无效。     DBCode:207
insert into goodsno(goo_code,goo_name,goo_no,spec,visible,goo_weight,pricetype) select  'I'+Id,goo_name,goo_no,spec,visible,goo_weight,pricetype from tt_import_goods  where goo_no not in (select goo_no from goodsno)
=================================
errordatetime:2004-05-19 17:55:59
user:sa
将 varchar 值 'I' 转换为数据类型为 int 的列时发生语法错误。     DBCode:245
insert into goodsno(goo_code,goo_name,goo_no,spec,visible,goo_weight,pricetype) select  'I'+Id,goo_name,goo_no,spec,visible,weight,pricetype from tt_import_goods  where goo_no not in (select goo_no from goodsno)
=================================
errordatetime:2004-05-20 13:38:16
user:sa
数据库发生错误.


错误代码:  208

错误信息:
Select error: 对象名 'downloadapp.dbo.hzpy' 无效。

错误行数:0
n_ds 错误Dataobject:dw_hzpy
错误的SQL:SELECT  hzpy.hz ,
           hzpy.py ,
           hzpy.py1     
FROM downloadapp.dbo.hzpy  as hzpy    
WHERE ( hzpy.hz = '番' )   


=================================
errordatetime:2004-05-20 15:42:06
user:sa
一个数据库错误已经被触发. 


错误号:  0

错误信息:
Select error: 聚合不应出现在 WHERE 子句中，除非该聚合位于 HAVING 子句或选择列表所包含的子查询中，并且要对其进行聚合的列是外部引用。

出错对象:n_tr
父对象:w_getorder_query_cxo
datawindow:dw_getorder_find_main_cxo
语法:select getmain.orderno,              getmain.getorderdate,              getmain.inputman,              getmain.sendorderdate,              getmain.memo,              getmain.haveout,           getmain.discountrate,              getmain.cus_code,           customer.cus_name as cus_name,               sum(num*price) as totalmoney,           isorder ,           orderstatus,           getmain.selfno,           pleaseproducedate,           pleaseproduceman,           getmain.handmanid,           getmain.havesend,           getmain.replace       from  getmain,getdetail,customer          where  getmain.cus_code *= customer.cus_code         and  getmain.orderno = getdetail.orderno       and     (sum(getdetail.havesendnum-getdetail.num)>=0)    and (getorderdate>='2004-05-01' and getorderdate<'2004-05-21')    group by           getmain.orderno,              getmain.getorderdate,              getmain.inputman,              getmain.sendorderdate,              getmain.memo,              getmain.haveout,              getmain.cus_code,           customer.cus_name ,                  isorder ,           orderstatus,           getmain.selfno,           pleaseproducedate,           pleaseproduceman ,           getmain.handmanid,           getmain.discountrate,           getmain.havesend,           getmain.replace