Folowing procedure update fails apparently because comment contains non us character ‘ä’. Goes through without ‘ä’.

 

Should this be so?

 

Pekka

 

########################################################################################################################################

unsuccessful metadata update

MODIFY RDB$PROCEDURES failed

while executing:

ALTER PROCEDURE P_KASITTELE_VUOKRAAIKA returns (LID Integer, DS Date, DU Date, VAG VarChar(38), HINTA1 Double Precision, HINTA_L Double Precision, KD Date, FK Integer, FK2 Integer)

AS

BEGIN

  /* Procedure body */

 

  FOR SELECT LAITE_ID, SISAAN_AIKA, ULOS_AIKA, VUOKRAAIKA_GUID, HINTA_1, HINTA_L, KASITELTY_PVA, FL_KASITELTY, FL_KASITTELY2

  FROM LAITE_VUOKRAAIKA

  WHERE (FL_KASITTELY2 <> 1) into :LID, :DS, :DU, :VAG, :HINTA1, :HINTA_L, :KD, :FK, FK2

  DO

                             BEGIN

    if ((FK = 0) and (DS is NULL)) THEN     /* Some Comment ä */

                             BEGIN

                             UPDATE LAITE_VUOKRAAIKA

                             set

                             LAITE_VUOKRAAIKA.FL_KASITELTY = 1,

                             LAITE_VUOKRAAIKA.KASITELTY_PVA = CURRENT_DATE,

                             LAITE_VUOKRAAIKA.FL_KASITTELY2 = 2,

                             LAITE_VUOKRAAIKA.HINTA_L = (SELECT LAITE_PVAHINTA_L FROM LAITE WHERE LAITE.LAITE_ID = :LID)

                             WHERE LAITE_VUOKRAAIKA.VUOKRAAIKA_GUID = :VAG;

                             END

   

                             END

  SUSPEND;

END