Creating Stored Procedure error

[Lauren Quantrell]

Trying to create a new stored procedure from code, running the code
below I just cut and pasted directly from the MS Knowledge Base, I get
the following error message:

Line 1: Incorrect syntax near 'prmCity'

Any ideas?
lq
Code:

Public Function CreateProc()

Dim strProc As String

strProc = "Create Procedure qryCustByCity " & _
"(prmCity varchar) as " & _
"select * from Customers where City = prmCity"

CurrentProject.Connection.Execute strProc

End Function

[Tom van Stiphout]

On 30 Oct 2003 14:18:53 -0800, la*************@hotmail.com (Lauren
Quantrell) wrote:

You forgot the @ sign. Try this:
strProc = "Create Procedure qryCustByCity " & _
"(@prmCity varchar) as " & _
"select * from Customers where City = @prmCity"

Note that an alternative to creating procedures on the fly is to send
the statement to a sproc that uses EXECUTE to run the passed in
statement.

-Tom.

Trying to create a new stored procedure from code, running the code
below I just cut and pasted directly from the MS Knowledge Base, I get
the following error message:

Line 1: Incorrect syntax near 'prmCity'

Any ideas?
lq
Code:

Public Function CreateProc()

Dim strProc As String

strProc = "Create Procedure qryCustByCity " & _
"(prmCity varchar) as " & _
"select * from Customers where City = prmCity"

CurrentProject.Connection.Execute strProc

End Function