DECLARE @tabname char(8)
SELECT @tabname = name
FROM name
WHERE id = 123
select @tabname
值:111
SQL查询器显示命令成功.
如何将sql中变量@tabname的值应用到DELPHI的EDIT2.TEXT中去.
如:在EDIT1.TEXT中输入ID后,EDIT2.TEXT就会显示与ID相对应的NAME.
SELECT @tabname = name
FROM name
WHERE id = 123
select @tabname
值:111
SQL查询器显示命令成功.
如何将sql中变量@tabname的值应用到DELPHI的EDIT2.TEXT中去.
如:在EDIT1.TEXT中输入ID后,EDIT2.TEXT就会显示与ID相对应的NAME.
SELECT @tabname = name
FROM name
WHERE id = 123
select @tabname AS ShowName //这里定义别名。
然后
ShowMessage(ADOQuery1.FieldByName('ShowName').AsString);
在EDit1的KeyPress事件里面
if Key = #13 then begin
if ADOQuery1.Active then
ADOQuery1.Active := false;
ADOQuery1.SQL.Text := 'DECLARE @tabname char(8) '
+ 'SELECT @tabname = name FROM name WHERE id = ' + Edit1.Text
+ ' select @tabname AS ShowName' //这里定义别名。
ADOQuery1.Active := true;
if not ADOQuery1.IsEmpty then
Edit2.Text := ADOQuery1.FieldByName('ShowName').AsString; end;