Passing Variables to and from ActiveX Controls
Written by Eric Smith, Northstar Computer Systems LLC
A reader asked about a problem he was having in passing values to and from an ActiveX control from VBScript. He had created a method on the control that has one Integer input argument and three Long output arguments. When he calls this method from VBScript, he’s getting Type Mismatch errors. This is due to the fact that VBScript only understands the concept of a Variant. Passing a Variant to a method expecting an Integer or a Long will cause an error.
The solution to this is to change the method to use the Variant data type exclusively. You may have to do some additional data validation before you call the method or once the data arrives within the method’s code. This is because a Variant can contain any data, from strings to numbers to dates. Be sure to make sure you’ve got the right type of data before starting calculations or manipulations on it.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 4/1/2000
|