#42000 Error message!!

[MYDAC100]

Hi,

When I run this code

Code: Select all

procedure TForm1.Button5Click(Sender: TObject);
begin
    Students_Table2.First;

    while Not   Students_Table2.Eof  do
    begin
          Students_Table2.Edit;

              Students_Table2.FieldByName('SENT').AsInteger := 1;
            Students_Table2.Post;

        Students_Table2.Next;
    end;
end;
end.

an error appears
"#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY = 843' at line 5."

May you please help me to fix it so i can edit my Database

[ViktorV]

Unfortunately, we haven't been able to reproduce the issue.
In order for us to be able to give you a detailed answer, we need to have a sample demonstrating the specified behavior. Therefore, please compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html including the scripts for creating database objects. Please also indicate the full and accurate versions of MySQL and MyDAC.

[MYDAC100]

I sent you the full code. waiting for your detailed answer

[MYDAC100]

Still waiting for your help ... yet, haven't received any respond .. I sent the email with the source code but no answer

[ViktorV]

To solve the issue, please, set the TMyTable.Options.QuoteNames property to True.

[MYDAC100]

It works :)

THANK YOU

[ViktorV]

Thank you for the interest to our product.
It is good to see that the problem has been solved.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.