菜鸟提问,关于access数据库的问题
错误:
INSERT INTO 语句包含下列未知的字段名: 'NwebCn_About.AboutNameSi'。确定键入的名称是正确的, 然后重试。
SQL语句:Insert into NwebCn_About (NwebCn_About.AboutNameSi,NwebCn_About.AboutNameTr,NwebCn_About.AboutNameEn,
NwebCn_About.ViewFlagSi,NwebCn_About.ViewFlagTr,NwebCn_About.ViewFlagEn,
NwebCn_About.ChildFlag,NwebCn_About.GroupID,NwebCn_About.Exclusive,
NwebCn_About.ContentSi,NwebCn_About.ContentTr,NwebCn_About.ContentEn) select '213','123','123','True','True','True','True',NwebCn_MemGroup.GroupID ,
(iif('专属','=','>=')),'123','123','123'
from NwebCn_MemGroup where NwebCn_MemGroup.GroupNameSi ='商业用户'
原sql语句:
Insert into NwebCn_About (NwebCn_About.AboutNameSi,NwebCn_About.AboutNameTr,NwebCn_About.AboutNameEn,NwebCn_About.ViewFlagSi,
NwebCn_About.ViewFlagTr,NwebCn_About.ViewFlagEn,NwebCn_About.ChildFlag,NwebCn_About.GroupID,
NwebCn_About.Exclusive,NwebCn_About.ContentSi,NwebCn_About.ContentTr,NwebCn_About.ContentEn) select '" + AboutNameSi + "','" + AboutNameTr + "','" + AboutNameEn + "','" + ViewFlagSi + "',
'" + ViewFlagTr + "','" + ViewFlagEn + "','" + ChildFlag + "',NwebCn_MemGroup.GroupID ,
(iif('专属','=','>=')),'" + ContentSi + "','" + ContentTr + "','" + ContentEn + "'
from NwebCn_MemGroup where NwebCn_MemGroup.GroupNameSi ='" + GroupNameSi + "'
注释:主要是两个表NwebCn_About 和NwebCn_MemGroup,两个表的关联字段是GroupID,表NwebCn_About中没有GroupNameSi字段,在插入时要从NwebCn_MemGroup表中找出GroupID放入NwebCn_About表,还有在前台得到的Exclusive是'专属'和'隶属'而存入NwebCn_About表时分别存入的是‘=’和‘>=’,下面附件是数据库,帮帮忙,弄了一天多了没整出来,急啊,谢谢