ActiveX Scripting

#1

I am creating an ActiveX VBScript to run in my DTS
package. Is it possible to create a function that
returns a value? Here is an example:

Function WhoIsIt(strText, strText2) AS Boolean
..
..
.. (some processing)

WhoIsIt = False
End Function

Thank you,
JLFelming

#2

Yes but you need to remove the AS Boolean. You don't declare
data types in VBScript. The function will return a variant.
You need to wrap the value in a conversion function if you
need to ensure a specific data type - CBool for a boolean.

-Sue

On Fri, 1 Oct 2004 04:08:55 -0700, "JLFleming"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I am creating an ActiveX VBScript to run in my DTS
package. Is it possible to create a function that
returns a value? Here is an example:

Function WhoIsIt(strText, strText2) AS Boolean
.
.
. (some processing)

WhoIsIt = False
End Function

Thank you,
JLFelming

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ActiveX Scripting

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

ActiveX Scripting - 10-01-2004 , 06:08 AM

Re: ActiveX Scripting - 10-01-2004 , 07:29 AM