При открытии TUniQuery:
Project raised exception class EMySqlException with message '
#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 'login = 'Администратор'' at line 7'.
потом появляется такое исключение 2 раза подряд.
Project rp.exe raised exception class EMyError with message '
#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 'login = 'Администратор'' at line 7'.
в ConnectionOptions:
charset = utf8
UseUnicode = True
вот запрос
Код: Выделить всё
select id, login, fio, phone1, phone2, is_expert_agent from users
where
is_deleted = 0 and
is_blocked = 0 and
password = :pass
login = :login
Код: Выделить всё
qCheckPass.ParamByName('login').AsString := edName.Text;
qCheckPass.ParamByName('pass').AsString := edPassword.Text;
qCheckPass.Open;
Что не так?
UniDAC 4.1.6
Delphi XE2