vb side when writing s proc

[pame1la]

I have wrote a s proc and want to call it in ma code.... all fines just getting a bit confused

Set prmName = objCmd.CreateParameter("Name", adVarChar, adParamInput, 15)
objCmd.Parameters.Append prmName

"Name" - should this be the name of the parameter in the s proc OR the column name in the table!!1!!!!

[brucevde]

With ADO the name can be whatever you want.

My advice, set the name argument equal to the parameter name.

[pame1la]

thanks 1 over question, I need to set ALL the parameters in the vb code that in the s procedure, correct? or can i ignore the parameters that do not apply; ie i want them sed to default values????

[techgnome]

If 1) defaults have been specified on the parameter, and 2) if you are not specifying any more parameters.

Example, if the SP takes 3 parameters, and you want to specify 1 & 3... you also have to specify 2.

Tg