IBExpert new Version


IBExpert Newsletter 01.07.02

Today we uploaded a new Version 2.2.0.2
of IBExpert on www.ibexpert.com

If you are registered customer and cannot
access the customer area, please check the
update end date from your registration form.
If you update right is already expired,
you can extend it for the next two years
with buying the same license(s) again in
our shop. See details on our Web Site
www.ibexpert.com

Description:


1. SP Editor, Trigger Editor: Added possibility to quickly
comment/uncomment procedure/trigger body. IBExpert scans
procedure/trigger body and comments blocks of statements
skipping user comments.
This feature is useful if you wish to deactivate procedure/trigger
temporarily.

THIS FEATURE ISN'T AVAILABLE IN IBEXPERT PERSONAL EDITION.


======== Example 1 (trigger):

-----------------------
CREATE TRIGGER ENTITIES_BI FOR ENTITIES
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
/* User comment */
IF (NEW.ENTITY_ID IS NULL) THEN
/* Another user comment */
NEW.ENTITY_ID = GEN_ID(GEN_ENTITIES_ID,1);
END
-----------------------

Trigger DDL after "Comment Trigger Body" operation:
-----------------------
CREATE TRIGGER ENTITIES_BI FOR ENTITIES
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
/* User comment */ /*$$IBE$$
IF (NEW.ENTITY_ID IS NULL) THEN
$$IBE$$*/ /* Another user comment */ /*$$IBE$$
NEW.ENTITY_ID = GEN_ID(GEN_ENTITIES_ID,1);
$$IBE$$*/ POST_EVENT '$$IBE$$';
END
-----------------------

Trigger DDL after "Uncomment Trigger Body" operation:

-----------------------
CREATE TRIGGER ENTITIES_BI FOR ENTITIES
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
/* User comment */
IF (NEW.ENTITY_ID IS NULL) THEN
/* Another user comment */
NEW.ENTITY_ID = GEN_ID(GEN_ENTITIES_ID,1);
END
-----------------------



======== Example 2 (stored procedure):

-----------------------
CREATE PROCEDURE P_TEST(ITEST SMALLINT)
RETURNS ( OTEST SMALLINT)
AS
BEGIN
oTest = iTest;
/* User Comment */
SUSPEND;
END
-----------------------

Procedure DDL after "Comment Procedure Body" operation:
-----------------------
CREATE PROCEDURE P_TEST(ITEST SMALLINT)
RETURNS ( OTEST SMALLINT)
AS
BEGIN /*$$IBE$$
oTest = iTest;
$$IBE$$*/ /* User Comment */ /*$$IBE$$
SUSPEND;
$$IBE$$*/ EXIT;
END
-----------------------

Procedure DDL after "Uncomment Procedure Body" operation:
-----------------------
CREATE PROCEDURE P_TEST(ITEST SMALLINT)
RETURNS ( OTEST SMALLINT)
AS
BEGIN
oTest = iTest;
/* User Comment */
SUSPEND;
END
-----------------------

Note, that IBExpert uses special char sequences ($$IBE$$) to properly
uncomment previously commented text. Don't modify these sequences manually!


2. Database Explorer: Now it is possible to deactivate/activate all database
stored procedures simultaneously. IBExpert uses way described above to
deactivate/activate stored procedures. Use database explorer popup menu to
activate/deactivate stored procedures.
THIS FEATURE ISN'T AVAILABLE IN IBEXPERT PERSONAL EDITION.

3. Database Explorer: Algorythm of deactivating/activating database triggers
was
improved. Now it's possible to choose activation/deactivation methods: you
can
recompile triggers with commented/uncommented body, make them
active/inactive
or use both ways simultaneously. Take into account that deactivating trigger
using comments
removes corresponding info about dependencies and therefore this way is
preferable if you wish, for example, to change type of a field referenced by
this
trigger.
THIS FEATURE ISN'T AVAILABLE IN IBEXPERT PERSONAL EDITION.


4. Script Executive, IBEScript: Now updates versions of objects (triggers,
procedures and
views) if table IBE$VERSION_HISTORY presents in database.

5. SQL Editor: Now remembers column widths in data grid and tries to restore
them next time when you execute the SELECT statement.

6. HTML Report: Table detail pages now include information about table
indices
and references.

7. HTML Report: It's possible to define default HTML report directory in
Database Registration Info | Default Paths.

8. Table Editor | Fields: Now indicates FK fields.

9. Added support for spanish and Italian Language (full install required).
When you select a Language, please check only one entry.

To change the language file after installation, copy the file from
Langfiles Directory to IBExpert main Directory and rename it to ibexpert.lng

10. Other bugfixes and improvements...



comments: please use our newsgroups on

German Language
news://victory.equitania.de/interbase.ibexpert.de

English Language
news://victory.equitania.de/interbase.ibexpert.en

Russian Language
news://victory.equitania.de/interbase.ibexpert.ru

French Language
news://victory.equitania.de/interbase.ibexpert.fr


The IBExpert Team

HK Software - Holger Klemt - Huntestrasse 15
D-26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378)