[RBASE-L] - Issue with CURSOR in RBW6.5++

[J.M. GRATIAS]

Hi all,


Is there any rules that prevent from using severals UPDATE on the same row
in a DECLARE CURSOR/WHILE LOOP ?

I am supprise that, in the following command file, the fisrt UPDATE works
correctly, but the second one return error 2378
'Cursor is not positionned on a valid row'.

Any idea ?

Using W98SE and RBW 6.5++ build 1.851xRT03 ...


DECLARE c2 CURSOR FOR SELECT numcde FROM T2commande WHERE cerreur IS NULL
OPEN c2

WHILE #PI <> 0 THEN
   FETCH c2 INTO vnumcde
   IF SQLCODE = 100 THEN
      BREAK
   ENDIF
   .........
   UPDATE T2commande SET cerreur = 99 WHERE CURRENT OF C2
   ........
   SET RULES ON
   UPDATE T2commande SET cerreur = NULL WHERE CURRENT OF C2
   ......
ENDWHILE

J.M. GRATIAS, Logimatique