The new version 0.40 fixes some bugs and have more features. Caché Monitor 0.40 is now ready for download ;)

Here are the details about the modifications:

Change Log and Release Notes for Caché Monitor 0.40:

Query Analyzer

• Executing stored procedures with CALL no longer raise exceptions if the resultset is bigger than 99 rows and the option block fetch is used.
• Better code completion in some situations

Server Navigator / Table Browser

• New options to limit the fetched data from server is integrated in the Table Browser. Max Rows and Max Chars can now be configured.
  
  Max Rows limit the rows fetched from server.
  Max Chars limit the size of charfields fetched from server
  
  This settings become saved and will be restored after Caché Monitor restart. To remove the limit just clear the field.

Please note: The option Max Rows works only if the table is NOT editable. This is the default, so after selecting a table the read only mode is set. To edit data you have to press the left button, this switch in "edit mode".

Technical details:

Unfortunately the Caché JDBC Driver ignore the Statement.setMaxRows() Method if the Statement is created with this options:

Connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE)

Today it is not clear what the reason is. It is possible that the JDBC Spec. require this behavior but it can be also a simple bug in the Caché JDBC Driver.