我找到原因了,因为2000或者XP在安装过程中它需要先将其解压到临时目录然后再安装,我们一般安装WIN2K后默认的用户名就是Administrator,临时目录是Documents and Settings\Administrator\Local Settings\Temp,而WINXP在安装时会提示输入一个超级用户名称,我想大部分人都是输入自己的中文名吧,临时目录就成了Documents and Settings\嘟嘟狼\Local Settings\Temp,而我习惯将临时目录改为我指定的目录M:\TEMP,因此出现了在我的机器上安装正常而别人的WINXP下很少能够正常安装的问题。 后来,问题解决了,我先用VB自带的打包工具打包,找出需要的文件,再用INSTALLSHILD打包,在2000和XP下都可以安装。
1.view2 ------------------------------------------------------------------------------- CREATE VIEW dbo.view2 AS SELECT LEFT(bianhao, 5) AS BianHao, MAX(ypname) AS YPName, MAX(candi) AS CanDi, MAX(guige) AS GuiGe, MAX(cangjiabh) AS cangjiabh FROM dbo.rukutab GROUP BY LEFT(bianhao, 5) ------------------------------------------------------------------------------2.TotalXSsuliang ---------------------------------------------------------------------------- CREATE VIEW dbo.TotalXSsuliang AS SELECT TOP 100 PERCENT LEFT(dbo.zongkutab.bianhao, 5) AS Bianhao, SUM(dbo.xiaosetab.suliang) AS ZongSuliang, dbo.zongkutab.ypname, dbo.zongkutab.zongsu, dbo.view2.CanDi, dbo.view2.GuiGe, MAX(dbo.xiaosetab.xiaoserq) AS xiaoserq, MIN(dbo.zongkutab.jinjia) AS jiajia, dbo.view2.cangjiabh FROM dbo.zongkutab INNER JOIN dbo.xiaosetab ON dbo.zongkutab.bianhao = dbo.xiaosetab.bianhao INNER JOIN dbo.view2 ON dbo.xiaosetab.bianhao = dbo.view2.BianHao GROUP BY LEFT(dbo.zongkutab.bianhao, 5), dbo.zongkutab.zongsu, dbo.zongkutab.ypname, dbo.view2.CanDi, dbo.view2.GuiGe, dbo.view2.cangjiabh ORDER BY LEFT(dbo.zongkutab.bianhao, 5) --------------------------------------------------------------------------------- 3.在SQL语句中存放: sql = "select * from TotalXSsuliang where zongsuliang>zongsu and xiaoserq between '"&last30day&"'and '"&nowday&"'"
sql4 = "select sum(suliang) as zongshu from xiaosetab where xiaoserq between '"&last30day&"'and '"&nowday&"' and bianhao='"&rs("bianhao")&"'"
用VB6自带的package&deployment向导打包后到98下可以安装,2000下就装不了!请问为什么,还要装什么东东吗??
例如:InstallWise
后来,问题解决了,我先用VB自带的打包工具打包,找出需要的文件,再用INSTALLSHILD打包,在2000和XP下都可以安装。
-------------------------------------------------------------------------------
CREATE VIEW dbo.view2
AS
SELECT LEFT(bianhao, 5) AS BianHao, MAX(ypname) AS YPName, MAX(candi) AS CanDi,
MAX(guige) AS GuiGe, MAX(cangjiabh) AS cangjiabh
FROM dbo.rukutab
GROUP BY LEFT(bianhao, 5)
------------------------------------------------------------------------------2.TotalXSsuliang
----------------------------------------------------------------------------
CREATE VIEW dbo.TotalXSsuliang
AS
SELECT TOP 100 PERCENT LEFT(dbo.zongkutab.bianhao, 5) AS Bianhao,
SUM(dbo.xiaosetab.suliang) AS ZongSuliang, dbo.zongkutab.ypname,
dbo.zongkutab.zongsu, dbo.view2.CanDi, dbo.view2.GuiGe,
MAX(dbo.xiaosetab.xiaoserq) AS xiaoserq, MIN(dbo.zongkutab.jinjia) AS jiajia,
dbo.view2.cangjiabh
FROM dbo.zongkutab INNER JOIN
dbo.xiaosetab ON dbo.zongkutab.bianhao = dbo.xiaosetab.bianhao INNER JOIN
dbo.view2 ON dbo.xiaosetab.bianhao = dbo.view2.BianHao
GROUP BY LEFT(dbo.zongkutab.bianhao, 5), dbo.zongkutab.zongsu,
dbo.zongkutab.ypname, dbo.view2.CanDi, dbo.view2.GuiGe,
dbo.view2.cangjiabh
ORDER BY LEFT(dbo.zongkutab.bianhao, 5)
---------------------------------------------------------------------------------
3.在SQL语句中存放:
sql = "select * from TotalXSsuliang where zongsuliang>zongsu and xiaoserq between '"&last30day&"'and '"&nowday&"'"
sql4 = "select sum(suliang) as zongshu from xiaosetab where xiaoserq between '"&last30day&"'and '"&nowday&"' and bianhao='"&rs("bianhao")&"'"
那应该行了(该注册的要注册)