How to look up the student information by entering the student's name, has been able to enter student id for the students, but can not input Chinese name,

CodePudding user response:

AdoQuery2. SQL. The Add (' select * from table1 where Sdnumber=: aa or Sdname=: bb ');
AdoQuery2. The Parameters. ParamByName (' aa '). The Value:=Edit6. Text;
AdoQuery2. The Parameters. ParamByName (" bb "). The Value:=Edit6. Text;

CodePudding user response:

reference 1st floor day return reply:

AdoQuery2. SQL. The Add (' select * from table1 where Sdnumber=: aa or Sdname="bb");
AdoQuery2. The Parameters. ParamByName (' aa '). The Value:=Edit6. Text;
AdoQuery2. The Parameters. ParamByName (" bb "). The Value:=Edit6. Text;

ok I'll try