MFC SQL语句调用错误

Question

strSQL.Format("insert into BabyInformation values(%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"
,1,"1","2","3","a","b","c","","","",a[7]);
 
strSQL.Format("update BabyInformation set  TEMPERATURE='%s',ROOM_TEMPERATURE='%s',LIGHT='%s',PISS='%s',NLID_QUILT='%s',CRY='%s',TIME='%s' where BED_NUMBER='%s'"
,"1","2","3","4","5","6","7","54"); 为什么insert语句可以正确执行 
而update语句则不能 
我是在原有表的基础上加了一列TIME 
在update中去掉TIME则能正确执行 
求高手解释 
SQLMFCupdatainsert

Answer 1

TIME是什么类型的？时间类型（datetime、timestamp？）？
如果是时间类型，则需要按照时间格式填写，如"2013-04-23 19:42:50"

Answer 2

文本类型，
在update中去掉TIME则能正确执行，比如strSQL="update BabyInformation set NAME='234' where BED_NUMBER='12'";  dlg.m_database.ExecuteSQL(strSQL); 
但将BED_NUMBER='12'改为TIME='12'错误（好像不能识别TIME列）
但insert语句strSQL.Format("insert into BabyInformation values(%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"
,1,"1","2","3","a","b","c","","","","12");怎能在ITEM列（最后）插入12