Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can VBS set arrays to be 1-based?
Message
From
04/11/2002 14:35:17
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00718470
Message ID:
00718637
Views:
26
>Alex;
>
>As far as I know the lower bound of VBScript is always 0, unlike VB, which allows you to declare any lower bound value you wish. I am not sure I understand the reason for the limitation as to why you cannot use a zero bound array but you do.
>
>Tom


I am writing an ASP app (VBS) that will have to do a lot of reporting in Excel format, posting an XLS embedded in the client's IE browser. As Excel itself is heavy for an IIS server, we purchased a product called ExcelWriter by SoftArtisans. It is a lighter object that basically mimics Excel's DOM and can also use XLS templates and populate with the contents of a recordset or an array.

During tests, for some reason the detail rows come pushed one row down and one column to the right from waht the template says. E.g. the first element come in cel B2 instead of A1.
If I put a row of column headers or titles they come out perfectly OK. Yet the detail (which comes from an array instead of a recordset) comes with a blank first rowand blank first column. Customer support is at a loss. The suspicion is the different between 0-based and 1-based arrays so I wanted to try it.

If that is not an option, then I will have to re-engineer the app to use a recordset and not the array produced from it (done for performance reasons).

Thanks for the info.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform