Board index Database Programming

Exceptions in recordset-loop.

Exceptions in recordset-loop.

Post by Willem van Berge » Sat, 30 Sep 2000 15:51:52



Hello database-gurus,

Why do I get these kind of messages in my debug output window:
"First-chance exception in PlayMPA.exe (KERNEL32.DLL): 0xE06D7363: Microsoft
C++ Exception."
with the following code? I only get the messages when the record is not
found in my ODBC recordset, so the while-loop exits without returning TRUE.
----------------------------------------
if ((IsEOF()) && (IsBOF())) return FALSE;
MoveFirst();
while (!IsEOF())
{
  if (m_Member == testValue) return TRUE;
  MoveNext( );

Quote:}

return FALSE;
------------------------------------------
Can somebody tell me what I am doing wrong. I have VC6 enterpise SP4 on
Win2000.

Willem van Bergen
--
"The headshrinkers, they want everything"
Radiohead - My iron lung (The bends)

FAQ nl.comp.cd-branden: http://members.home.nl/cdrfaq/

 
 
 
Top

1. infinite loop during exception handling?

I'm studying for my OCP, first exam, and I'm trying to reproduce what my
book says might be an infinite loop caused by one's exception handler
throwing an uncaught exception of its own.  I've done an example, but
can't produce an infinite loop.

Am I doing something wrong?

Book I'm using is 'OCP Oracle DBA - Next Generation Training' by Willard
Baird II, New Riders (c. 99; p. 108).

DECLARE
  status  NUMERIC;
  num     NUMERIC;
BEGIN
  DBMS_OUTPUT.put_line('Beginning test...');
  num := 1/0;
  DBMS_OUTPUT.put_line('Test successful...');
EXCEPTION
WHEN OTHERS THEN
  BEGIN
    status := SQLCODE;
    num := 2/0;
  END;
END;

2. How does one handle field size exception?

3. continue loop after an exception

4. Interbase character transliteration

5. SPL on exception in loop

6. Oracle & Optical Jukebox

7. How to loop recordset and lock the table at stored procedure

8. 3 oracle dba certification books for 1 book's price

9. Looping a recordset in Stored Procedures

10. Loop through a recordset inside a stored procedure?

11. Looping through a recordset in a stored procedure HOWDOI

12. Loop thru recordset

13. @@IDENTITY within outer recordset loop


All times are UTC
Board index