It is time for version 0.24 :) PDF Print E-mail
Caché Monitor 0.24 released, now the sql editor shows foreign key join suggestions.

join-suggestion
The details for V 0.24 are:

    Query Analyzer:
    - Foreign Key JOIN suggestion. After typing the keyword ON Caché Monitor displays JOIN suggestion

join-suggestion

    - The keyword CALL shows Stored Procedures in autocomplete box
    - More autocomplete for sql keywors, functions, etc.
    - More keyword highlighting
    - Result to grid is now working ;-)

result-to-grid

    - Result to grid fetch only blocks with blocksize of 100, after scrolling at the end next block is fetched
    - Selecting a piece of text in the Script Editor will execute only that piece
    - PK Columns are marked with red icon in autocomplete dialog

    SQL Scanner
    - DROP INDEX can be executed on selected index from SQL Scanner(Redundant Index finder)
    - CREATE INDEX can be executed on selected index from SQL Scanner(Cached Queries Scanner)
    - SQL Scanner / Cached Queries Scanner is no more case sensitive
   
    General
    - Login dialog box pops up if User or Password is missing in server konfiguration

login-dialog

    - Caché Monitor is running on Java 6.0
    - x button on the "select server/namespace" dialog has same behavior like the cancel button
    - namespaces are now cached for each server, the connect to database with query analyzer is now faster. You can refresh the namespace information at this time only on the query analyzer connect dialog!



    - schemas are now cached for each server/namespace, the connect to database with query analyzer is now faster. The refresh of the schemas only works on "select namespace" dialog, so if the namespaces are refreshed, the schemas also.
    - An Error dialog box displays the error message if something is happend

Consider please, from this version the file structure changed! Your configured Servers are lost. From now Cache Monitor use his own folder to save caching data and configuration information. You can find this folder in your home folder. The name of this folder is: ".cm"
To use your sql history with 0.24 copy the "sqlhistory.dat2" from your home folder in ".cm".