Answer the question
In order to leave comments, you need to log in
Triggers in Delphi?
Is it possible to use full triggers in Delphi using default tools? I have a database with logins and passwords for authentication + triggers for updating / changing the password in the table:
CREATE TRIGGER onHashUpdate
BEFORE UPDATE ON users
FOR EACH ROW BEGIN
SET NEW.password = md5(NEW.password);
END
CREATE TRIGGER onHashInsert
BEFORE INSERT ON users
FOR EACH ROW BEGIN
SET NEW.password = md5(NEW.password);
END
Answer the question
In order to leave comments, you need to log in
Before you do this stupid thing, I will warn you: storing md5 from a password in 2016 is idiotic. Slightly less than keeping the password open.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question