存储过程如下:
CREATE PROCEDURE SpecItemStructure_list
@zjy varchar(255)=nullas
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里传递过去就提示有未闭合的单引号?
CREATE PROCEDURE SpecItemStructure_list
@zjy varchar(255)=nullas
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里传递过去就提示有未闭合的单引号?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货