Query2:= TADOQuery.Create(nil);
try
with Query2 do
begin
Connection:= ADOConMysql; //连接正常
Close;
SQL.Clear;
SQL.Add('Select max(body_id) as maxbody_id from sms_body');
Open; //提示“未指定的错误”
MaxBody_ID:= FieldByName('maxbody_id').AsInteger;
Close;
end;
finally
Query2.Free;
end;
try
with Query2 do
begin
Connection:= ADOConMysql; //连接正常
Close;
SQL.Clear;
SQL.Add('Select max(body_id) as maxbody_id from sms_body');
Open; //提示“未指定的错误”
MaxBody_ID:= FieldByName('maxbody_id').AsInteger;
Close;
end;
finally
Query2.Free;
end;
MYSQL>Select max(body_id) as maxbody_id from sms_body;
没有问题
2.Select max(body_id) as maxbody_id from sms_body 这个SQL在mysql数据库中执行一下看看是否正常
2.执行了正常,能得出最大值
另外还有一条SELECT语句也报同样的错误,不知什么原因?