类似的问题又来了,为什么说我的UPDATE语法错误 oledb连接access数据库,用update语句更新记录,报语法错误。但把语句直接在access里运行可以通过,为啥哪里的问题? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 string strUptCom = "UPDATE CusBaseInfo SET IDDate='" + cisUpdate.IDDate + "',Name='" + cisUpdate.Name + "'," + "BirthDay='" + cisUpdate.BirthDay + "'" + ",Sex='" + cisUpdate.Sex + "',IfWedded='" + cisUpdate.IfWedded + "'," + "IfSy='" + cisUpdate.IfSy + "',Stature='" + cisUpdate.Stature + "'" + ",Avoirdupois='" + cisUpdate.Avoirdupois + "',Telephone='" + cisUpdate.Telephone + "',Handset='" + cisUpdate.Handset + "'," + "Address='" + cisUpdate.Address + "',Eating='" + cisUpdate.Eating + "',Splanchnic='" + cisUpdate.Splanchnic + "'," + "Sleeping='" + cisUpdate.Sleeping + "',Slzq='" + cisUpdate.Slzq + "',Character='" + cisUpdate.Character + "'," + "Sporting='" + cisUpdate.Sporting + "',Drinking='" + cisUpdate.Drinking + "',BonesAndMuscle='" + cisUpdate.BonesAndMuscle + "'," + "IllHis='" + cisUpdate.IllHis + "',Tongue='" + cisUpdate.Tongue + "',Shape='" + cisUpdate.Shape + "'," + "Other='" + cisUpdate.Other + "',Skin1='" + cisUpdate.Skin1 + "',Skin2='" + cisUpdate.Skin2 + "'," + "Skin3='" + cisUpdate.Skin3 + "',Skin4='" + cisUpdate.Skin4 + "',Living='" + cisUpdate.Living + "'," + "PerOfTre='" + cisUpdate.PerOfTre + "',Requirement='" + cisUpdate.Requirement + "' WHERE ID='" + cisUpdate.ID + "' AND Type='" + cisUpdate.Type + "'"; 语句在access下直接运行没问题的 语句在access下直接运行没问题的------你确信程序中构造的sql语句和access中测试的语句相同? 在access中运行的语句是调试的时候直接拷下来的数据库的使用权限也没问题,因为insert是可以的 我以前也遇到过这种问题,可能还是access数据库的原因,我最后选择放弃,改用sql 根据帖子里的楼层号自动发帖,这个能做到吗? 编程在线 如何将菜单添加到指定位置?或者通过代码调整菜单位置? ArrayList做为DataList的数据源时,如何绑定ArrayList中的值对象到DataList中? 读取状态字段 《求助》水晶报表如何分类统计? 怎么比较x.x.x与x.x.x的值 在win2003中怎样安装sql2000的sp3a? 如何做到一个popup窗口 救救孩子吧,c#窗体 html控件与web窗体控件的区别? 大家看看下面这段代码有什么错误?
"BirthDay='" + cisUpdate.BirthDay + "'" + ",Sex='" + cisUpdate.Sex + "',IfWedded='" + cisUpdate.IfWedded + "'," +
"IfSy='" + cisUpdate.IfSy + "',Stature='" + cisUpdate.Stature + "'" + ",Avoirdupois='" + cisUpdate.Avoirdupois +
"',Telephone='" + cisUpdate.Telephone + "',Handset='" + cisUpdate.Handset + "'," + "Address='" + cisUpdate.Address +
"',Eating='" + cisUpdate.Eating + "',Splanchnic='" + cisUpdate.Splanchnic + "'," + "Sleeping='" + cisUpdate.Sleeping +
"',Slzq='" + cisUpdate.Slzq + "',Character='" + cisUpdate.Character + "'," + "Sporting='" + cisUpdate.Sporting +
"',Drinking='" + cisUpdate.Drinking + "',BonesAndMuscle='" + cisUpdate.BonesAndMuscle + "'," + "IllHis='" + cisUpdate.IllHis +
"',Tongue='" + cisUpdate.Tongue + "',Shape='" + cisUpdate.Shape + "'," + "Other='" + cisUpdate.Other +
"',Skin1='" + cisUpdate.Skin1 + "',Skin2='" + cisUpdate.Skin2 + "'," + "Skin3='" + cisUpdate.Skin3 +
"',Skin4='" + cisUpdate.Skin4 + "',Living='" + cisUpdate.Living + "'," + "PerOfTre='" + cisUpdate.PerOfTre +
"',Requirement='" + cisUpdate.Requirement + "' WHERE ID='" + cisUpdate.ID + "' AND Type='" + cisUpdate.Type + "'";
数据库的使用权限也没问题,因为insert是可以的