大家帮我看一下
存储过程:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[TK_ClientInfo_EditInfo]@ClientID int ,
@userrealname varchar(30),
@sex int,
@birthday varchar(20),
AS
begin
UPDATE TK_ClientInfo
SET
[userrealname] = @userrealname
,[sex] = @sex
,[birthday] = @birthday
WHERE ClientID = @ClientID
end
MFC 程序语句:
cSql= " exec TK_ClientInfo_EditInfo ' "+m_ClientID+" ','"+ m_Name +"',' " + m_sex + " ','"+ m_birthday +"'";怎么修改不了啊?
存储过程:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[TK_ClientInfo_EditInfo]@ClientID int ,
@userrealname varchar(30),
@sex int,
@birthday varchar(20),
AS
begin
UPDATE TK_ClientInfo
SET
[userrealname] = @userrealname
,[sex] = @sex
,[birthday] = @birthday
WHERE ClientID = @ClientID
end
MFC 程序语句:
cSql= " exec TK_ClientInfo_EditInfo ' "+m_ClientID+" ','"+ m_Name +"',' " + m_sex + " ','"+ m_birthday +"'";怎么修改不了啊?
你可以在TOAD工具里面试着用同样的参数调试一下该存储过程
cSql= "exec TK_ClientInfo_EditInfo "+m_ClientID+",'"+ m_Name +"'," + m_sex + ",'"+ m_birthday +"'"; 很明显id,sex应该为整形
@ClientID int ,
@userrealname varchar(30),
@sex int,
@birthday varchar(20),