CString sql,input_sql,mubiao_sql;
sql = "";
input_sql = "";
mubiao_sql = "";....
input_sql = "i,s";
mubiao_sql = "x,y";
sql = "INSERT INTO total(" + mubiao_sql +") Values(" + input_sql +")";
m_pConnection->Execute(sql,&RecordsAffected,adCmdText);代码如上
有错误,问如何实现这种形式呢!
sql = "";
input_sql = "";
mubiao_sql = "";....
input_sql = "i,s";
mubiao_sql = "x,y";
sql = "INSERT INTO total(" + mubiao_sql +") Values(" + input_sql +")";
m_pConnection->Execute(sql,&RecordsAffected,adCmdText);代码如上
有错误,问如何实现这种形式呢!
就行了!不用太复杂的!
mubiao_sql = "x,y";
如果x,y是NUMBER型的,把input_sql="i,s",改成input_sql="1,2"就行了
如果x,y是VARCHAR2型的,把input_sql="i,s",改成input_sql="'i','s'"
我直接写
m_pConnection->Execute("INSERT INTO total([id],[pxbmc]) VALUES(3,'无敌')",&RecordsAffected,adCmdText);
会出现IDispatch 3027错误
为什么啊
id的数据类型是bigint,pxbmc的数据类型是Varchar