Devart Forums

i can do it with 1 value;
in store procedure: REturn 1
in delphi;
execute;
returningvalue := Parambyname('REturnvalue').AsInteger;

but how do i return more than 1 value from a stored procedure?

Use follow syntax

CREATE PROCEDURE ALL_TYPES_IO
@c_int int = 0 OUTPUT ,
@c_bigint bigint = 0 OUTPUT
AS
SELECT @c_int = 111

See MSDN for details

Thanks. It is working as expected.
rashid