Page 1 of 1
out param with mydac Stored Procedure
Posted: Mon 23 Jan 2006 22:22
by nbalcarres
Any one know how to use the out param with mydac?
I can use IN param - but not out. I get all kinds of errors.
Posted: Tue 24 Jan 2006 13:17
by Ikar
MySQL Server data transferring protocol does not support output parameters.
To get parameters from MySQL Server you should use SELECT statements. For example:
Code: Select all
with MyQuery1 do begin
SQL.Add('SELECT 1+1 INTO @par1;');
SQL.Add('SELECT 2+2 INTO @par2;');
SQL.Add('SELECT @par1 AS p1, @par2 AS p2;');
Open;
Label1.Caption := FieldValues['p1'];
Label2.Caption := FieldValues['p2'];
end;
Posted: Mon 24 Jul 2006 20:35
by Guest
I am just looking at these messages and am wondering what exactly does the
1+1 and 2+2 stand for?
Posted: Tue 25 Jul 2006 07:08
by Antaeus
This test example only shows how to return values from the server and it does not have any practical meaning.