[Firebird-devel] [ firebird-Field-test-1477056 ] Invalid ROW_COUNT variable value after FETCH CURSOR

[SourceForge.net <no...@so...>]

Field-test item #1477056, was opened at 2006-04-26 20:22
Message generated for change (Comment added) made by dimitr
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1477056&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core Engine
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Erick P. R. Almeida (ephillipe)
Assigned to: Nobody/Anonymous (nobody)
Summary: Invalid ROW_COUNT variable value after FETCH CURSOR

Initial Comment:
My code:

DECLARE C CURSOR FOR (SELECT CS.SESSION_ID FROM
CHAT_SECAO CS);

BEGIN
  WHILE (1 = 1) DO
  BEGIN
    FETCH C INTO :ID_OPERADOR;
    IF (ROW_COUNT = 0) THEN
      LEAVE;
  END
  CLOSE C;
END;


  ROW_COUNT returns 0 (ZERO) when ID_OPERADOR returns a
 exact data.

----------------------------------------------------------------------

>Comment By: Dmitry Yemanov (dimitr)
Date: 2006-04-30 07:49

Message:
Logged In: YES 
user_id=61270

ID_OPERADOR cannot "return" anything. When no row is fetched
(stream EOF), previous value of the variable is preserved. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1477056&group_id=9028