| 问题原因： |
通过事件跟踪器发现,在进入发出商品记账时有运行一条"SELECT DISTINCT DISPATCHLIST.DLID AS ID, DISPATCHLISTS.IDLSID AS AUTOID,
CONVERT(CHAR(10),DISPATCHLIST.DDATE,121) AS DDATE,
DISPATCHLIST.CDLCODE, DISPATCHLISTS.CWHCODE,
WAREHOUSE.CWHNAME,DISPATCHLIST.CRDCODE, RD_STYLE.CRDNAME,
DISPATCHLISTS.CINVCODE, INVENTORY.CINVNAME,
LTRIM(STR(CAST(DISPATCHLISTS.IQUANTITY AS DECIMAL(38,2)),38,2)) AS IQUANTITY,
NULL AS IUNITCOST,NULL AS IPRICE,
LTRIM(STR(INVENTORY.IINVRCOST,40,4)) AS IPUNITCOST,
LTRIM(STR(DISPATCHLISTS.IQUANTITY*INVENTORY.IINVRCOST,40,2)) AS IPPRICE,
0 AS BRDFLAG,DISPATCHLIST.CVOUCHTYPE AS CVOUCHTYPE,INVENTORY.CVALUETYPE,
DISPATCHLISTS.ICORID,DISPATCHLIST.CBUSTYPE AS CBUSTYPE,
DISPATCHLIST.DDATE AS DSDATE,NULL AS CACCOUNTER,'销售' AS CSOURCE,
NULL AS CBUSCODE,CONVERT(CHAR,CONVERT(MONEY,DISPATCHLIST.UFTS),2) AS UFTS INTO TEMPFCSPTABLE
FROM ((((((((( DISPATCHLIST LEFT JOIN DISPATCHLISTS
ON DISPATCHLIST.DLID = DISPATCHLISTS.DLID) LEFT JOIN WAREHOUSE
ON WAREHOUSE.CWHCODE = DISPATCHLISTS.CWHCODE) LEFT JOIN SALETYPE
ON SALETYPE.CSTCODE = DISPATCHLIST.CSTCODE)LEFT JOIN RD_STYLE
ON RD_STYLE.CRDCODE = SALETYPE.CRDCODE)LEFT JOIN INVENTORY
ON DISPATCHLISTS.CINVCODE = INVENTORY.CINVCODE) LEFT JOIN RDRECORDS
ON RDRECORDS.IDLSID = DISPATCHLISTS.IDLSID) LEFT JOIN RDRECORD
ON RDRECORD.ID = RDRECORDS.ID) LEFT JOIN SALEBILLVOUCHS
ON SALEBILLVOUCHS.IDLSID = DISPATCHLISTS.IDLSID) LEFT JOIN SALEBILLVOUCH
ON SALEBILLVOUCH.SBVID = SALEBILLVOUCHS.SBVID)
WHERE DISPATCHLIST.CACCOUNTER IS NULL
AND DISPATCHLISTS.CWHCODE IN ('01','11','12','13','21','22','23','24','25','26','31','32','33')
AND (ISNULL(DISPATCHLISTS.IQUANTITY,0)<>0) AND (RDRECORD.CACCOUNTER IS NULL)
AND (DISPATCHLIST.CACCOUNTER IS NULL) AND (NOT DISPATCHLIST.CVERIFIER IS NULL)
AND DISPATCHLIST.DDATE <= '2003-11-30' AND BSERVICE=0 AND INVENTORY.BINVTYPE=0
AND SALEBILLVOUCH.CACCOUNTER IS NULL AND ((INVENTORY.CMONTH IS NULL)
OR RIGHT(INVENTORY.CMONTH,2)<11) AND (ISNULL(DISPATCHLIST.CBUSTYPE,'')='分期收款'
AND DISPATCHLIST.CVOUCHTYPE='05')"的语句,将此语句放入查询分析器中运行后提示"服务器: 消息 2714，级别 16，状态 6，行 2
数据库中已存在名为 'TEMPFCSPTABLE' 的对象。"
这可能是在软件进入时没有去判断该表是否存在,在退出软件时有,那么如果是在非正常退出请况下就会出错啦!
|