` Printed Icetips Article

Icetips Article

SQL Related Articles: Calling stored procedure with return parameter
2003-02-28 -- Lesley Dean

Newsgroups: TopSpeed.Products.Drivers

Hi Jim, Benjamin,

I would just change Jim's example to NORESULTCALL if there is no result set
being returned. And I would add a fileerror check.

eg:
retval long
OptionalInParam string(20)
code
  bind('retval',retval)
  bind('OptionalInParam', OptionalInParam)
  View{prop:sql}= '&RetVal = NORESULTCALL
StoredProcName(&OptionalInParam[IN])'
  if errorcode() = 90 then stop('Error in StoredProcName: ' &
fileerrorcode() & ' ' & fileerror()).
   message('RetVal='&retval)

HTH.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com


"jim kane"  wrote in message
news:3e5eec57$1@news.softvelocity.com...
> retval long
> OptionalInParam string(20)
> code
>   bind('retval',retval)
>   bind('OptionalInParam', OptionalInParam)
>   View{prop:sql}= '&RetVal = CALL StoredProcName(&OptionalInParam[IN])'
>    message('RetVal='&retval)
>
> "Benjamin Krajmalnik"  wrote in message
> news:3e5eba4c$1@news.softvelocity.com...
> > I have a stored procedure which has an optional parameter.  Backend is
MS
> > SQL Server 2000.
> >
> > The stored procedure returns an integer value.
> > What is the proper way to call it via prop:sql?
> >
> >
>
>

Printed May 3, 2024, 5:03 am
This article has been viewed/printed 35113 times.
Google search has resulted in 102 hits on this article since January 25, 2004.