CString name;
float fPV;
CString strRTTime;
long iTagId;
数据库中:char name,bigint tagindex,float PV,datetime datatime;
strCmdText="INSERT INTO historydb.dbo.hisanalog (name,tagindex,pv,datatime) VALUES ( '"+strTagName+"',"+iTagId+","+fPV+",'"+strRTTime+"' )";一条简单的插入语句报错:error C2666: '+' : 4 overloads have similar conversions
不知道为什么错,单引号,双引号还有加号各是什么意思?正确的写法应该是什么?请各位大侠帮帮忙!
float fPV;
CString strRTTime;
long iTagId;
数据库中:char name,bigint tagindex,float PV,datetime datatime;
strCmdText="INSERT INTO historydb.dbo.hisanalog (name,tagindex,pv,datatime) VALUES ( '"+strTagName+"',"+iTagId+","+fPV+",'"+strRTTime+"' )";一条简单的插入语句报错:error C2666: '+' : 4 overloads have similar conversions
不知道为什么错,单引号,双引号还有加号各是什么意思?正确的写法应该是什么?请各位大侠帮帮忙!
--name 和 datetime是SQL保留字要加[].试一下!
strCmdText.Format("INSERT INTO historydb.dbo.hisanalog (name,tagindex,pv,datatime) VALUES ( %s,%ld,%f,%s )",strTagName,iTagId,fPV,strRTTime);
但我还是想知道上面那种方法应该怎么写,还望各位高手不吝赐教!
"...."+fPV.ToString("#.00")