Login
Templates, Tools and Utilities
for Clarion Developers
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 2002-04-11 -- Frank Vestjens Newsgroups: softvelocity.products.c55ee
Alexander,
> Somebody knows as to receive OUT parameter from stored procedure
> (SYBASE SQL Anywhere 5.5.04). Would be grateful for an example.
Instead of using stored procedures I use stored functions which return the
value which normally is returned in the OUT parameter.
I normally do the following:
I've got a file called dummy with 1 field called CstringField varchar(4096)
in the database.
File definition (Clarion)
Dummy
FILE,DRIVER('ODBC'),OWNER(Connect),NAME('Dummy'),PRE(DCDum),BINDABLE,THREAD
Record RECORD,PRE()
CStringField CSTRING(4096)
END
END
I then do the following in Clarion code:
OPEN(Dummy)
Dummy{PROP:Sql} = 'SELECT StoredFunction('& InPar1 &','& InPar2 &')'
Next(Dummy)
!now Dum:CstringField contains the result from the stored function.
Maybe this can help you.
Regards,
Frank
InforIT bv
Today is May 1, 2024, 12:54 pm This article has been viewed 35113 times. Google search has resulted in 45 hits on this article since January 25, 2004.
|
|