ACCESS SQL 问题

[noteasytoregister]

下面两段分别执行是可以的，但放在一起运行会出错：语法错误（操作符丢失）在查询表达式‘1 INSERT...‘。

UPDATE GLVchMaxNum
set FNum=1

INSERT INTO GLVchMaxNum(FPeriod,FGroup,FNum)
SELECT 12,'REC',1

[ACMAIN_CHM]

UPDATE GLVchMaxNum
set FNum=1;

INSERT INTO GLVchMaxNum(FPeriod,FGroup,FNum)
SELECT 12,'REC',1;

[noteasytoregister]

[noteasytoregister]

[Quote=引用 1 楼 acmain_chm 的回复:]

UPDATE GLVchMaxNum
set FNum=1;

INSERT INTO GLVchMaxNum(FPeriod,FGroup,FNum)
SELECT 12,'REC',1;
[/Quote]
运行出现：在SQL语句结尾之后找到字符。

[ACMAIN_CHM]

ACCESS不支持一次提交两个SQL语句，一次只能提交一个。