SCRIPT(OUT CSVXMLA CLOB)
BEGIN
  DECLARE InfoCursor CURSOR FOR InfoStmt;
  DECLARE InfoSql VarChar Default '';
  DECLARE CSVSql CLOB Default ''; 
 
  set InfoSql = 'SELECT * FROM .....';
  
  PREPARE InfoStmt FROM InfoSql;
  OPEN InfoCursor; 
    FETCH FIRST FROM InfoCursor..... 
    .
    .
             
    FETCH NEXT FROM InfoCursor....
  END WHILE;     
 
  CLOSE InfoCursor;
  UNPREPARE InfoStmt;
  
  set CSVXMLA = CSVSql;
  set log message to CSVSql;
END

---

 Comments

---

Basically the problem was the same as with incident report #2819, namely that a modal dialog is repeatedly shown until it crashes the EDB Manager. The parameters for SQL statements and scripts are not handled slightly differently via a tab sheet at the bottom of the SQL window, instead of in a modal dialog. Apart from that, however, the functionality is still the same.

---

 Resolution

---

Fixed Problem on 10/22/2008 in version 2.02 build 3

---

 Products Affected

---

ElevateDB Additional Software and Utilities