Devart Forums

Hi

When using a stored procedure with parameters the second time that the stored procedure is run, it returns the error above. I tested the stored procedure with a straight select procedure and it runs without errors. I put together a test case and can send it to you with a database.

I also checked that my libmysql.dll file is the latest version. I am using mysql server ver 5.0.41 and client ver 5.1.1. I also include the bds 2006 error which may mean something to you below.

+ $88[0A0B20C0]{mydac100.bpl} Myclasses.TMySQLConnection.MySQLError + $88
+ $2A[0A0B4762]{mydac100.bpl} Myclasses.TMySQLCommand.Check + $2A
+ $B1[0A0B5891]{mydac100.bpl} Myclasses.TMySQLCommand.Execute + $B1
+ $10[09F08058]{dac100.bpl } Craccess.TCRRecordSet.ExecCommand + $10
+ $F[09F08073]{dac100.bpl } Craccess.TCRRecordSet.ExecFetch + $F
+ $1B[0A0B7087]{mydac100.bpl} Myclasses.TMySQLRecordset.InternalOpen + $1B
+ $31[09EF814D]{dac100.bpl } Memdata.TData.Open + $31
+ $0[09F0008C]{dac100.bpl } Memdata.TMemData.Open + $0
+ $76[0A0B4342]{mydac100.bpl} Myclasses.TMySQLConnection.CreateProcCall + $76
+ $8D[0A0C8485]{mydac100.bpl} Myaccess.CreateProcCall + $8D
+ $C2[0A0D0132]{mydac100.bpl} Myaccess.TCustomMyStoredProc.PrepareSQL + $C2
+ $8[0A0D050C]{mydac100.bpl} Myaccess.TCustomMyStoredProc.OpenCursor + $8
+ $47[09F1D24B]{dac100.bpl } Dbaccess.TCustomDADataSet.SetActive + $47
+ $0[51F4AC2E]{rtl100.bpl } TypInfo.TypInfo.SetOrdProp (Line 1318, "TypInfo.pas" + 27) + $0
+ $6[20EFD30A]{designide100.bpl} DesignEditors.DesignEditors.TEnumProperty.SetValue (Line 1402, "DesignEditors.pas" + 5) + $6
+ $24[20FDDD84]{vclide100.bpl} IDEInspListBox.IDEInspListBox.TInspListBox.SetPropValue (Line 1145, "ideinsplistbox.pas" + 40) + $24
+ $7[20FDF414]{vclide100.bpl} IDEInspListBox.IDEInspListBox.TInspListBox.ListAccept (Line 1636, "ideinsplistbox.pas" + 6) + $7
+ $12[20FDACF6]{vclide100.bpl} IDEListBtns.IDEListBtns.TListButton.CloseUp (Line 752, "IDEListBtns.pas" + 14) + $12
+ $6[5205CA19]{vcl100.bpl } Controls.Controls.TWinControl.WndProc (Line 7246, "Controls.pas" + 105) + $6
+ $4[00500EAB]{idectrls100.bpl} IDEWideStdCtrls.IDEWideStdCtrls.TWideCustomListBox.WndProc (Line 4425, "IDEWideStdCtrls.pas" + 14) + $4
+ $0[51F60BC0]{rtl100.bpl } Classes.Classes.StdWndProc (Line 11572, "classes.pas" + + $0
+ $6A[7E418731]{USER32.dll } GetDC + $6A
+ $14A[7E418811]{USER32.dll } GetDC + $14A
+ $122[7E4189C8]{USER32.dll } GetWindowLongW + $122
+ $A[7E418A0B]{USER32.dll } DispatchMessageW + $A

Please send me an email address and I will upload the test case with the database

Thanks
Marius

There are several known problems with stored procedures of MySQL returning result sets. A couple of them is described in the FAQ. If the problem you have encountered differs from the description, please send your test sample to mydac*crlab*com.

Can you repost the link to the FAQ mentioned. I am curious what known issues there are for MySQL and stored procedures.

Thank you,

Daniel

We have updated the link. Sorry for the inconvenience.

Sorry, Adventurer, but the FAQ link above my original post is still broke and shows a 404 error, file not found.

Can you repost the link to the FAQ mentioned. I am curious what known issues there are for MySQL and stored procedures.

Maybe, you could just post a new, fresh link to the FAQ he spoke about.

Thank you,

Daniel