COleDateTime m_strDate;
CString myDate;
myDate=m_strDate.Format("%Y-%m-%d");
_variant_t strQuery;
strQuery = "insert into Product (Date) values ('"+myDate+"')";
Date的数据类型为日期/时间。数据库为Access
我想把输入的日期(例如:2000-5-12)插入到表Product的Date字段。
为什么总是有Insert into 语法错误?
请各位高手指教。谢谢!!!
strQuery = "insert into Product ([Date]) values (#" + myDate + "#)";
strQuery = "Update Product set [Date]=#"+myDate+"# where ProductID="+m_strProductID;