Devart Forums

Hello,

I am trying to use TMyCommand component in MyDAC 5.80 in Delphi 7 to execute the following query:

UPDATE Emp
SET
Password = PASSWORD(:Password)
WHERE
id = :Old_id AND Password = PASSW0RD(:Old_Password)

But the parser would give the error:

#42000 Function <mydbname>.PASSWORD does not exist.

What should I do?

Hello,

You made a misprint in your SQL code, you typed the zero symbol '0' instead of the 'O' symbol. Here is a correct code:

Thank you!

It was certainly a typo!

If any other questions come up, please contact us.