Question

在MFC下操作数据库的SQL语句

CString strsql ="select count(*) from [User] as num where UserId =1111 and Pwd = 111111";
m_recordest = m_command->Execute((tagVARIANT *)strsql.AllocSysString(),NULL,adCmdText);
这样运行会出错

m_command->CommandText = “select count(*) from [User] as num where UserId =1111 and Pwd = 111111";
m_recordest = m_command->Execute(NULL,NULL,adCmdText);
这样没错 上面的怎么改才对呢 谢了。

Answer 1

Cstring strsql = "..."型银型;
m_command->卜猜搏清CommandText = (_bsrt_t)strsql;

m_recordest = m_command->Execute(NULL,NULL,adCmdText);

Answer 2

select count(*) as num from [User] where UserId =1111 and Pwd = 111111

追问

不是这个原因 这个 是问的时候 复制错了的 我的就是你写的那样的 。。。。。。