` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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? > > > > > >

Today is November 23, 2024, 2:17 am
This article has been viewed 35319 times.
Google search has resulted in 102 hits on this article since January 25, 2004.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription