insert {TDepart_Roles} ([DepartID],[RoleID],[Remark],[CreaterID],[CreateTime]) Values('"& DID &"','"& RID &"','"& STR &"','"& CurrentUserID &"','"& date.today() &"')"
语句有问题。语法应该为，你没加INTO
Insert into Table2(a, c, d) select a,c,5 from Table1
INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')
试试这个
insert into {TDepart_Roles} ([DepartID],[RoleID],[Remark],[CreaterID],[CreateTime]) Values('"& DID &"','"& RID &"','"& STR &"','"& CurrentUserID &"','"& date.today() &"')"
加好友 
发短信
Post By：2011/5/17 22:01:00 [只看该作者]
