Page 1 of 1

StoredProc Net packets out of order

Posted: Thu 30 Aug 2007 09:53
by Eric_Chen
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;

Posted: Fri 31 Aug 2007 12:26
by Antaeus
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.