Passing Parameters

  • Thread starter Thread starter Nexus
  • Start date Start date
N

Nexus

hi, i'm tryng to supply two different values into two
parameters in my stored procedure.
Both the values comes from my VB variables. The variables
are strVendorID
and strCompanyName. The parameters in my stored procedure
are @VendorID and @CompanyName

My codes are as followed:

--
DoCmd.RunSQL "EXECUTE insert_vendor1 @VendorID = " &
strVendorID
--

The above codes only passes one value to one parameter.
How can i pass both values into both the parameter?

Is it something like this?

DoCmd.RunSQL "EXECUTE insert_vendor1 @VendorID = " &
strVendorID, "@CompanyName = " & strCompanyName
 
Hello, Nexus!
You wrote in message on Thu, 16 Sep 2004 23:38:05 -0700:

N> How can i pass both values into both the parameter?
N> Is it something like this?

DoCmd.RunSQL "EXECUTE insert_vendor1 @VendorID = " & strVendorID & _
", @CompanyName = '" & strCompanyName & "'"

With best regards, Igor.
ICQ: 111469481
 
Nexus said:
hi, i'm tryng to supply two different values into two
parameters in my stored procedure.
Both the values comes from my VB variables. The variables
are strVendorID
and strCompanyName. The parameters in my stored procedure
are @VendorID and @CompanyName

My codes are as followed:

--
DoCmd.RunSQL "EXECUTE insert_vendor1 @VendorID = " &
strVendorID
--

The above codes only passes one value to one parameter.
How can i pass both values into both the parameter?

Is it something like this?

DoCmd.RunSQL "EXECUTE insert_vendor1 @VendorID = " &
strVendorID, "@CompanyName = " & strCompanyName
Click to expand...
 
Back
Top