Login
`
Templates, Tools and Utilities
|
||
Add a comment to an Icetips ArticlePlease 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!
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, 6:30 am This article has been viewed 35215 times. Google search has resulted in 55 hits on this article since January 25, 2004.
|
|