ADOquery1.sql.Text:='select name form name where hykh='''+Edit2.text+''''; 或者 ADOquery1.sql.Text:='select name form name where hykh='+QuotedStr(Edit2.text); 两单引号连写,在字符串中表示一个单引号.
//引号不对,有双引号 ADOquery1.sql.Text:='select name form name where hykh="'+Edit2.text+'"'; ADOquery1.execsql; -------------------------ADOquery1.sql.Text:=format('select name form name where hykh=''%s''',[Edit2.text]);
procedure TForm1.Button2Click(Sender: TObject); begin DBGrid1.Columns[0].Width:= 25; end;
ADOquery1.sql.Text:='select name form name where hykh="'+Edit2.text+'"'; ADOquery1.open;
ADOquery1.sql.Text:='select name FROM name where hykh="'+Edit2.text+'"'; //不是form ADOquery1.open; //对于查询,用open ;而update,insert用exesql;
或者
ADOquery1.sql.Text:='select name form name where hykh='+QuotedStr(Edit2.text);
两单引号连写,在字符串中表示一个单引号.
ADOquery1.sql.Text:='select name form name where hykh="'+Edit2.text+'"';
ADOquery1.execsql;
-------------------------ADOquery1.sql.Text:=format('select name form name where hykh=''%s''',[Edit2.text]);
begin
DBGrid1.Columns[0].Width:= 25;
end;
ADOquery1.open;
//不是form
ADOquery1.open;
//对于查询,用open ;而update,insert用exesql;