DELPHI向SQLSERVER存储过程传递参数的问题???急!!!
存储过程如下:
CREATE PROCEDURE SpecItemStructure_list
@zjy varchar(255)=null
as
declare @SQLSTRING NVARCHAR(1000)
SET @SQLSTRING='SELECT * FROM structure_specitem where '+@zjy+' order by 项目编号'
exec sp_executesql @SQLSTRING
GO
-------------------------------------------------------------------------------------
DELPHI代码如下:
sqlstr:='项目编号='''''+trim(cbbxmbh.text)+'''';
with data_modeler.specitemstructure do
begin
close;
prepared := false;
parameters.parambyname('@zjy').Value := sqlstr;
prepared := true;
open;
end;
--------------------------------------------------------
问题:sqlstr中值为'项目编号=''2012-04-001''',在查询分析器中能执行,可从DELPHI里传递过去就提示有未闭合的单引号?