Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can VBS set arrays to be 1-based?
Message
 
To
04/11/2002 14:35:17
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00718470
Message ID:
00718659
Views:
20
>>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;

Thank you for the information. I considered purchasing that product. I use their file upload and it works great! About 2 years ago customer support was very responsive from SoftArtisans! However, for about the last year I have not enjoyed my relationship with them. I guess they are "too busy".

Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform