29-Apr-2002 -- news_V324

Piper: Version 3.24 Fixes and New Features

• View CLOBS as XML! If you have the HTML Output option turned on, and if you double-click on a CLOB that has been returned from a query, the entire CLOB will be read from the database and presented in the Browser window as XML! This is a great new fetaure for those who store serialised XML documents in CLOBs.
• CLOBs can be viewed as either HTML, XML, or TEXT as chosen by pressing the appropriate button in the new CLOB toolbar. These options are also available via the menu option View->Clob.
• Each CLOB you have chosen to view in its entirity (by double-clicking on a cell in the output area) is available as a file called Piper_Clob_r_c. in your system temporary directory, where and are the row/col numbers of the cell you clicked, and is either htm, xml or txt depending on the CLOB view format you have chosen.
• Improved Handling of RAW data type (eg. as seen in select * from v$session)
• BUG FIX: After a no-data-found query, the bind variables correspondening to the parameters of that query were being emptied. This was incorrect behaviour.. they now retain their values from before the query. Note however that if the query was successful, these bind variables are updated from the last row of data received.
• BUG FIX: In the Bind Variables window, When "Sort" is chosen to order the list, the bind variable name and value fields were not consistent with the currently selection. This is now fixed.
• BUG FIX: Fixed Access Exception that occured in some cases when the Bind Variables Window was visible during execution of a query.