` Returning values from Stored Procedures using OUT (Michael Gould) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

SQL Related Articles: Returning values from Stored Procedures using OUT
2002-04-11 -- Michael Gould
 
Newsgroups: TopSpeed.Products.Drivers Alexander, Here is the example program from the help file. This should get you started. Michael Gould Example: PROGRAM MAP CallProc(STRING) END MyFile FILE,DRIVER('MSSQL') Record RECORD c LONG . . Ret LONG Out STRING(10) CODE BIND('RetCode', Ret) BIND('Out', Out) CallProc('&RetCode = CALL StoredProcTest(''1'',&Out)') MESSAGE('Return value of StoredProcTest =' & Ret) MESSAGE('Output parameter of StoredProcTest =' & Out) CallProc PROCEDURE(Str) CODE MyFile{PROP:SQL} = Str Note: The above example shows how to return an output parameter. "Alexander" wrote in message news:3cb55d57@news.softvelocity.com... > Hi All! > > Somebody knows as to receive OUT parameter from stored procedure > (SYBASE SQL Anywhere 5.5.04). Would be grateful for an example. > > Best regards, > Alexander > >


Today is November 21, 2024, 3:46 am
This article has been viewed 35214 times.
Google search has resulted in 55 hits on this article since January 25, 2004.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: