I am using D5 and am trying to create a stored procedure via an ADO Command.
If I have a very simple stored procedure it seems to work but if I have a
complicated one I get an error stating that no values was given for one or
more required parameters.  I am just trying to create the stored procedure,
not execute it.

Does anybody have any thoughts on how I can create a stored procedure via
ADO?

Thanks

Richard

Further to my last post I have since discovered that the problem occurrs
when I have a Label in my stored procedure.

For some reason having a label (e.g. GOTOHERE: ) is flagged as an error.  I
suspect it has something to do with the colon at the end.

Richard

Try settling the Paramcheck property to false.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

I had already set that to false since I had run into a similar situation
some months back where I had a SQL string with too many double-quotes in it
(it seems that it would get confused if you had an odd number of them which
in my case was fine because it was just a character embedded into a
description).

Richard