Par2: Receiving OUT parameter in SQL Anywhere 2002-04-11 -- Frank Vestjens > 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.
Printed May 2, 2024, 6:30 pm This article has been viewed/printed 35116 times. |