TMyStoredProcedure Can Return Param?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

TMyStoredProcedure Can Return Param?

Post by CHIN » Mon 29 Nov 2004 01:07

If i call stored procedure using TMyStoredProcedure,
some params is declare 'OUT' or 'INOUT', TMyStoredProcedure
can be auto return/update param?


Create Procedure MyValue(
IN InValue Int,
OUT ReturnResult)
Set ReturnResult = InValue * 10;

Call MyValue(12, @a)//

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: TMyStoredProcedure Can Return Param?

Post by Ikar » Mon 29 Nov 2004 12:05

Now this ability is enabled only for Result. Full support of OUTPUT parameters most probably will be available with MySQL Server 5.0 beta release.

Post Reply