Topic: (SOLVED) syntax ERROR
Hello, I am adapting your Login form with password change to a database in Mysql, (10.1.34-MariaDB), and cause several problems in the syntax of the query. Example
Before:
SQLExecute ('INSERT INTO users (login, password, read, write, remove, search, administrator) VALUES ("admin", "admin", 1, 1, 1, 1, 1);');
After. (works):
SQLExecute ('INSERT INTO users (login, `password`,` read`, `write`,` remove`, search, administrator) VALUES ("admin", "admin", 1, 1, 1, 1, 1); ');
In this I have problems:
s: = VarToStr (SQLExecute ('SELECT count (id) FROM users WHERE (login =' '' + frmLogin.edUser.Text + '' ') AND (password =' '' + frmLogin.edPassword.Text + '' ' ); '));
What would be the correct one for this problem?