代码是这样的:
form1.Query1.SQL.Add('DELETE from temp');
form1.Query1.SQL.Add('INSERT INTO temp(ss,sum)');
form1.Query1.SQL.Add('SELECT f(xy)1_1.s1, SUM(x1.Pxx*x1.Pyx) AS Expr1');
form1.Query1.SQL.Add('FROM f(xy)1_1 INNER JOIN x1');
form1.Query1.SQL.Add('ON f(xy)1_1.s1 = x1.S1 OR f(xy)1_1.s1 = x1.S2 OR f(xy)1_1.s1 = x1.S3');
form1.Query1.SQL.Add('GROUP BY f(xy)1_1.s1');
最开始运行报错:Invalid use of keyword.
Token:INSERT
去掉第一句话后运行又报错:Invalid use of keyword.
Token:sum)
SELECT
这是怎么回事啊
form1.Query1.SQL.Add('DELETE from temp');
form1.Query1.SQL.Add('INSERT INTO temp(ss,sum)');
form1.Query1.SQL.Add('SELECT f(xy)1_1.s1, SUM(x1.Pxx*x1.Pyx) AS Expr1');
form1.Query1.SQL.Add('FROM f(xy)1_1 INNER JOIN x1');
form1.Query1.SQL.Add('ON f(xy)1_1.s1 = x1.S1 OR f(xy)1_1.s1 = x1.S2 OR f(xy)1_1.s1 = x1.S3');
form1.Query1.SQL.Add('GROUP BY f(xy)1_1.s1');
最开始运行报错:Invalid use of keyword.
Token:INSERT
去掉第一句话后运行又报错:Invalid use of keyword.
Token:sum)
SELECT
这是怎么回事啊
现在去掉第一句话都能顺利运行了,可是一加上这句,就又报错了
是不是两段语句不能这样接着阿
form1.Query1.Close;
form1.Query1.SQL.Clear;
form1.Query1.SQL.Add( )