SQl.Add('select * from User where Name='''+Trim(Edit1.Text)+'''');
或者: SQl.Add('select * from User where Name='+QuotedStr(Trim(Edit1.Text)));
Trim 没错。 引号比较多,重复了。楼上对
begin With Frm_Interface.ADO_user do begin Close; SQL.Clear; // Parameters.ParamByName('name').Value:=edit1.Text; // SQl.Add('select * from User where Name=''Edit1.Text'''); SQl.Add('select * from User where Name='''+Trim(Edit1.Text)+''''); // close; Open; If RecordCount>0 then出现FORM子语句问题,是怎么回事情
SQl.Add('select * from User where Name='+QuotedStr(Trim(Edit1.Text)));
With Frm_Interface.ADO_user do
begin
Close;
SQL.Clear;
// Parameters.ParamByName('name').Value:=edit1.Text;
// SQl.Add('select * from User where Name=''Edit1.Text''');
SQl.Add('select * from User where Name='''+Trim(Edit1.Text)+'''');
// close;
Open;
If RecordCount>0 then出现FORM子语句问题,是怎么回事情