s:=Trim(tv1.Selected.Text); qry1.Close; qry1.SQL.Clear; qry1.SQL.Add('select * from dir where caption='+s); qry1.Open; strngrd1.Cells[1,n]:=qry1.Fields[1].AsString; strngrd1.Cells[2,n]:=qry1.Fields[2].AsString;这个哪里出错了啊??
sql.add('select * from dir where id=2');可用为什么编程字符串就不能用了啊??
SQL中用字符型参数用 QuotedStr函数 qry1.SQL.Add('select * from dir where caption='+QuotedStr(s));
直接用Stringgrid1.Cells[i,j]:=''
赋值就行了啊
qry1.Close;
qry1.SQL.Clear;
qry1.SQL.Add('select * from dir where caption='+s);
qry1.Open;
strngrd1.Cells[1,n]:=qry1.Fields[1].AsString;
strngrd1.Cells[2,n]:=qry1.Fields[2].AsString;这个哪里出错了啊??
qry1.SQL.Add('select * from dir where caption='+QuotedStr(s));