Error on LOCK after update to MyDac 5.10.0.10

[snuggles99]

After updating to MyDac 5.10.0.10 (unfortunately I can't recall which version I was using before, I think it was the first 5 Ver.) I get for some tables an error when I try to lock them as per following commands:

Code: Select all

procedure Tdm.TransaktionAnfangen(DataSet: TDataSet);
begin
  If not (DataSet as TMyTable).Connection.InTransaction then
  begin
    (DataSet as TMyTable).Connection.StartTransaction;
    (DataSet as TMyTable).Lock(lrImmediately);  //<== COMMAND THAT FAILS
  end
  else MessageDlg('DB bereits in Transaktion', mtError, [mbOK],0);
  FormNcmmain.TransaktionAnzeige;
end;

I get an error:

Code: Select all

#42000You have and error in your SQL Syntax...near':GESUCHID FOR UPDATE' at line 3'....

To me it seems the newst version does something different than the older one, as really absolutely nothing was changed on the tables, the database server, the source code.

Can you help or do you have a hint?

Thanks in advance.

[Antaeus]

I could not reproduce the problem.
Please send me a complete small sample at evgeniyD*crlab*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- exact version of your IDE (including personality name for Delphi 2005, and BDS 2006);
- exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.