CREATE PROCEDURE sqlsong @inputfield varchar(20),@inputcontent varchar(20)
AS
select * from db where @inputfield=@inputcontent
GOwith adostoredproc1 do
begin
close;
parameters.ParamByName('@inputfield').Value :=combobox1.Text ;
parameters.ParamByName('@inputcontent').Value :=trim(edit1.Text );
prepared:=true;
open;
end;我想问一下,为什么执行时,没有找到记录(实际上有记录);当然存储名设置正确。
AS
select * from db where @inputfield=@inputcontent
GOwith adostoredproc1 do
begin
close;
parameters.ParamByName('@inputfield').Value :=combobox1.Text ;
parameters.ParamByName('@inputcontent').Value :=trim(edit1.Text );
prepared:=true;
open;
end;我想问一下,为什么执行时,没有找到记录(实际上有记录);当然存储名设置正确。
CREATE PROCEDURE sqlsong @inputfield varchar(20),@inputcontent varchar(20)
AS
declare @sqltext varchar(1000)
set @sqltext = 'select * from db where ' + @inputfield + '=' + '''' + @inputcontent + ''''
exec(@sqltext)
GO