StoredProc Net packets out of order

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Eric_Chen
Posts: 1
Joined: Thu 30 Aug 2007 09:44

StoredProc Net packets out of order

Post by Eric_Chen » Thu 30 Aug 2007 09:53

I got this Error------StoredProc Net packets out of orderxxxxx



procedure TForm1.Button1Click(Sender: TObject);
var x: Integer;
begin

MyProc.StoredProcName:= 'Proc1';
MyProc.Prepare;
MyProc.ParamByName('Param1').AsString:= 'aaa';
MyProc.Open;

X:= MyProc.RecordCount;

No Problem above------------------------------------------

if X = 0 then

Begin
MyProc.StoredProcName:= 'Proc2';----------------------Error Here
MyProc.Prepare;
MyProc.ParamByName('Param1').AsString:= 'bbb';
MyProc.Execute;

End;





end;

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 31 Aug 2007 12:26

Thank you for information. This is a bug of the MySQL prepared protocol and stored procedures. This bug cannot be avoided in MyDAC. You should give up using prepared stored procedures.

Post Reply