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
CHIN

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?

Example:

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

Call MyValue(12, @a)//
---------------------------------

Ikar
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