Subject | What is wrong? |
---|---|
Author | Francisco Antonio Vieira Souza |
Post date | 2004-08-02T15:05:42Z |
begin
FOR
SELECT
(SELECT MAX(v.quantfinal) FROM VALORTARIFAS t
WHERE t.codtabela=:tarifa GROUP BY quantfinal) PESO_FINAL,
v.valorfaixa
FROM VALORTARIFAS v
WHERE v.codtabela = :tarifa
INTO :peso_final, :valor
DO
suspend;
end
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause).
FOR
SELECT
(SELECT MAX(v.quantfinal) FROM VALORTARIFAS t
WHERE t.codtabela=:tarifa GROUP BY quantfinal) PESO_FINAL,
v.valorfaixa
FROM VALORTARIFAS v
WHERE v.codtabela = :tarifa
INTO :peso_final, :valor
DO
suspend;
end
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause).