Re: Need help in Optional keyword

Set default values for your optional parameters and check to see if they are
still set to the default....

i.e., byval optional strConnString as string = vbnullstring

if strConnString = vbNullString then
    '-- No conn string was passed in
else
    '-  Do whatever
end if

HTH,

Jesse



>From: "P. S. Manikandan" <[email protected]>
>Reply-To: Technical discussion of VBCOM <[email protected]>
>To: [email protected]
>Subject: [VBCOM] Need help in Optional keyword
>Date: Fri, 19 Jul 2002 01:16:35 -0700
>
>Hi...
>          I have one function with three parameters. First one is
>mandatory , second and third parameters are optional. Now i want to find
>out whether value is passed for the optional parameters or not...how can i
>do this...any suggestions..
>
>Regards
>Manikandan
>
>You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
>subscribe to other DevelopMentor lists at http://discuss.develop.com.


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.