Login
`
Templates, Tools and Utilities
|
||
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"
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.
|
|