Are you using parameter style general?
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Naughton
Sent: Monday, July 19, 2010 2:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: Calling Stored Procedures from WonderWare InTouch
I tried changing the parameter definitions in the procedure to type
varchar, and I changed the parameters in the procedure itself to
"varying const", but that still didn't work.
I think the real problem is on the WonderWare side -- for some reason,
the command that I'm defining doesn't think it has the number and type
of parameters that I think I'm telling it that it does have. The
question now is why. Their tech support so far
has been no help, but we have a consultant who says he has worked with
this before, so maybe he'll have some ideas ....
Thanks for the help,
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
VarChar vs Char maybe? Is your stored procedure expecting VarChar's?
Most
likely that is how they are being passed.
Also, did you use a SBREAK to set a break point and see what value got
passed to your stored procedure? You didn't say what the stored
procedure is
written in.
Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential
and solely for the use of the intended recipient. If you are not the
intended recipient or the person responsible for delivering to the
intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please
notify us immediately by replying to it and then delete it from your
computer.
midrange.com
