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
Printed May 1, 2024, 2:48 pm This article has been viewed/printed 35113 times. Google search has resulted in 45 hits on this article since January 25, 2004. |