"** No parameter" error when using TADOQuery to connect to the ACCESS database

iosa1234

"** No default parameters" error when using TADOQuery to connect to the ACCESS database
 I want to query the password field in the username table (with two fields of password and name) in the database username (already bound) in ACCESS.
 In fact, it is the user login interface to see if the passwords match
          ADOQuery1-> Close ();
          ADOQuery1-> SQL-> Clear ();
          ADOQuery1-> SQL-> Text = "select password from username where name =" + Edit2-> Text;
 // I don't know if this sentence is wrong

          ADOQuery1-> Open ();
          AnsiString b = ADOQuery1-> FieldByName ("Password")-> AsString;
 // I use Edit3 to accept the password. How can I compare it with b to determine whether the password is correct or not?

starfull

ADOQuery1->FieldByName("Password")->AsString;
select password? case

iosa1234

Still not okay
The data in the table is line 210520
My username enter line
It prompts that'line' has no default value

freedomsoli

It should be wrong in this sentence ADOQuery1->SQL->Text ="select password from username where name=" + Edit2->Text;
If your username is int, then this sentence is correct. If it is not int, you are definitely wrong.
"select password from username where name ='" + Edit2->Text + "'";//Note that I added 2'

iosa1234

Thank you very much! The problem is solved!