ADOQuery1.SQL.Text := 'select * from tblstaff where sname=' + QuotedStr(Edit1.Text);
如果是数值型,就是 Quoterint()吗?^_^
字符串型: adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from tblstaff where sname='''+trim(edit1.text)+''''); adoquery1.open;adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from tblstaff where sname='+trim(edit1.text)); adoquery1.open;数值型
那么,怎么用delphi来访问SQL的变量呀?
adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from tblstaff where sname='''+trim(edit1.text)+''''); adoquery1.open;str:=adoquery1.fieldbyname('你要的属性名称).asstring;
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from tblstaff where sname='''+trim(edit1.text)+'''');
adoquery1.open;adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from tblstaff where sname='+trim(edit1.text));
adoquery1.open;数值型
adoquery1.sql.clear;
adoquery1.sql.add('select * from tblstaff where sname='''+trim(edit1.text)+'''');
adoquery1.open;str:=adoquery1.fieldbyname('你要的属性名称).asstring;
query1.SQL.Add('set @aa=getdate()');
query1.SQL.Add('select @aa as c');
query1.Close;
query1.Open;
showmessage(query1.fieldbyname('c').AsString);
是将输入的数据转换为字符串型