Subject | Re: problem with "for" in procedure |
---|---|
Author | ronaldorezende |
Post date | 2003-05-15T18:11:10Z |
The QTD is the output. and NOTA a local variable.
Why this not sucess?
My table DIARIO_PROVA_ALUNO has severals registers.
begin
QTD = 0;
FOR SELECT NOTA_PROVA FROM DIARIO_PROVA_ALUNO INTO :NOTA
DO
BEGIN
QTD = QTD+NOTA;
END
suspend;
end
Why this not sucess?
My table DIARIO_PROVA_ALUNO has severals registers.
begin
QTD = 0;
FOR SELECT NOTA_PROVA FROM DIARIO_PROVA_ALUNO INTO :NOTA
DO
BEGIN
QTD = QTD+NOTA;
END
suspend;
end