access中的sql语句 语法错误
在程序中使用总是报错,复制到sql视图就没错,为什么,语句如下INSERTINTOTrainingRegistration(name,sex,birthday,city,...
在程序中使用总是报错,复制到sql视图就没错,为什么,
语句如下
INSERT INTO TrainingRegistration(name,sex,birthday,city,education,National,Major,Duty,Appellation,Unit,Dept,Address,Post,Tel,Mobile,Email,IDCardNo,EducationExperience,WorkExperience,ProductionLicense,RegisterCategory,CreateTime,Creator,Status) VALUES('',1,'2010-11-03','','','','','','','','','','','','','','','','','','','2010-11-03','',1)
仍然报错
UPDATE 语句的语法错误。
UPDATE TrainingRegistration SET name='刘德华',sex=1,birthday='1969-11-23',city='香港',education='本科',National='汉,' Major='表演',Duty='演员',Appellation='影帝',Unit='新艺宝',Dept='演员',Address='香港',Post='100000',Tel='12121212',Mobile='12121212',Email='dfaf@fg.dfgh',IDCardNo='235689451212545',EducationExperience='fffffffffffff',WorkExperience='ggggggggggggggggggg',ProductionLicense='1245',RegisterCategory='1245',CreateTime='2010-11-02',Creator='ffffffff',Status='1' where id=1 展开
语句如下
INSERT INTO TrainingRegistration(name,sex,birthday,city,education,National,Major,Duty,Appellation,Unit,Dept,Address,Post,Tel,Mobile,Email,IDCardNo,EducationExperience,WorkExperience,ProductionLicense,RegisterCategory,CreateTime,Creator,Status) VALUES('',1,'2010-11-03','','','','','','','','','','','','','','','','','','','2010-11-03','',1)
仍然报错
UPDATE 语句的语法错误。
UPDATE TrainingRegistration SET name='刘德华',sex=1,birthday='1969-11-23',city='香港',education='本科',National='汉,' Major='表演',Duty='演员',Appellation='影帝',Unit='新艺宝',Dept='演员',Address='香港',Post='100000',Tel='12121212',Mobile='12121212',Email='dfaf@fg.dfgh',IDCardNo='235689451212545',EducationExperience='fffffffffffff',WorkExperience='ggggggggggggggggggg',ProductionLicense='1245',RegisterCategory='1245',CreateTime='2010-11-02',Creator='ffffffff',Status='1' where id=1 展开
2个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询