在Excel 2003中用VBA编写宏的时候
发现string类型的字符串在长度493的时候就被截断了,请问哪位高手知道是怎么回事么?
代码如下:Dim sqlWPstrq1 as string sqlWPstr1 = "SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], "
sqlWPstr1 = sqlWPstr1 + " IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) "
sqlWPstr1 = sqlWPstr1 + " AS [Planned Completion Date], "
sqlWPstr1 = sqlWPstr1 + " [Actual Start Date], [Actual Completion Date], [Work Estimate], [Hours Utilized], [% Completion] AS [Actual % Completion], "
sqlWPstr1 = sqlWPstr1 + " DateDiff('d',[Planned start Date],[Planned Completion Date]) AS [Total Duration], DateDiff('d',[Planned Start Date],now()) AS [Elapsed Day], " i = Len(sqlWPstr1)最终查到组成的sqlWPstr1为:"SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) AS [Planned Completion Date], [Actual Start Date], [字符串被截断了,长度i为493
发现string类型的字符串在长度493的时候就被截断了,请问哪位高手知道是怎么回事么?
代码如下:Dim sqlWPstrq1 as string sqlWPstr1 = "SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], "
sqlWPstr1 = sqlWPstr1 + " IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) "
sqlWPstr1 = sqlWPstr1 + " AS [Planned Completion Date], "
sqlWPstr1 = sqlWPstr1 + " [Actual Start Date], [Actual Completion Date], [Work Estimate], [Hours Utilized], [% Completion] AS [Actual % Completion], "
sqlWPstr1 = sqlWPstr1 + " DateDiff('d',[Planned start Date],[Planned Completion Date]) AS [Total Duration], DateDiff('d',[Planned Start Date],now()) AS [Elapsed Day], " i = Len(sqlWPstr1)最终查到组成的sqlWPstr1为:"SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) AS [Planned Completion Date], [Actual Start Date], [字符串被截断了,长度i为493
解决方案 »
- 想写个图片处理的dll,让ASP调用,不知道错哪里了
- 打印问题还没解决,帮帮我,再放100分
- 为了实现一个功能,各位请帮忙。
- 怎样判断某个文件在本地硬盘存在?
- vb中字符型换数字型是什么函数?
- 请教高手如何做一个按钮command1,把Windows的剪贴板中的图片存成aa.jpg
- 如何获取背景颜色值,高分求救!!
- HELP**急急***vb窗体中的数据显示问题********
- 我想在asp中用treeview控件,但我不知道treeveiew控件的progID,要怎样才能知道呢?
- ★★★★★与CGI有关,数据流处理问题★★★★★VB高手请来拿分
- 简单的取字符串问题
- 提取access数据表中,某个字段所有不同的值到一个集合对象
Dim sqlWPstrq1 as string 'Dim sqlWPstr1 as string ,你多了一个q sqlWPstr1 = "SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], "
sqlWPstr1 = sqlWPstr1 + " IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) "
sqlWPstr1 = sqlWPstr1 + " AS [Planned Completion Date], "
sqlWPstr1 = sqlWPstr1 + " [Actual Start Date], [Actual Completion Date], [Work Estimate], [Hours Utilized], [% Completion] AS [Actual % Completion], "
sqlWPstr1 = sqlWPstr1 + " DateDiff('d',[Planned start Date],[Planned Completion Date]) AS [Total Duration], DateDiff('d',[Planned Start Date],now()) AS [Elapsed Day], " i = Len(sqlWPstr1)
我返回的I值是 493 但是sqlWPstr1的值是:SELECT [Service]+'/'+[Module-Release]+'/'+[WPID]+'/'+[Name] AS [WP Info], [Planned Start Date], IIf([Projected Completion Date] Is Not Null,[Projected Completion Date],[Planned Completion Date]) AS [Planned Completion Date], [Actual Start Date], [Actual Completion Date], [Work Estimate], [Hours Utilized], [% Completion] AS [Actual % Completion], DateDiff('d',[Planned start Date],[Planned Completion Date]) AS [Total Duration], DateDiff('d',[Planned Start Date],now()) AS [Elapsed Day],