IBExpert New Version 2003.11.06 ready for Download

IBExpert Newsletter 6.11.2003

Today we uploaded a new Version 2003.11.06
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


1. We have changed the version numbering. Now number of the
version corresponds with the date of build.


2. Table Editor:

* Indices tab: fixed problem with incorrect displaying of indices
sorting.

* Fields tab: the field dependencies list now includes indices,
primary and foreign keys.

* Constraints tab: added support for new Firebird feature -
user-defined constraint index names.

* Added possibility to change field default value.
Because the server itself doesn't allow to alter the default
value of a field using ALTER TABLE we have implemented a
kind of workaround:

1. First, IBExpert creates the temporary field with necessary
DEFAULT value:

ALTER table ADD IBE$$TEMP_COLUMN column_type DEFAULT
new_default.

2. Second, IBExpert copies the RDB$DEFAULT_SOURCE and
RDB$DEFAULT_VALUE
values of the just created temporary field into
RDB$DEFAULT_SOURCE
and RDB$DEFAULT_VALUE of the field which should be altered:

UPDATE RDB$RELATION_FIELDS F1
SET
F1.RDB$DEFAULT_VALUE = (SELECT F2.RDB$DEFAULT_VALUE
FROM RDB$RELATION_FIELDS F2
WHERE (F2.RDB$RELATION_NAME
= 'table')
(F2.RDB$FIELD_NAME =
'IBE$$TEMP_COLUMN')),
F1.RDB$DEFAULT_SOURCE = (SELECT F3.RDB$DEFAULT_SOURCE
FROM RDB$RELATION_FIELDS F3
WHERE (F3.RDB$RELATION_NAME
= 'table')
(F3.RDB$FIELD_NAME =
'IBE$$TEMP_COLUMN'))
WHERE (F1.RDB$RELATION_NAME = 'table')
(F1.RDB$FIELD_NAME = 'column')

3. After that IBExpert drops the temporary field:

ALTER TABLE table DROP IBE$$TEMP_COLUMN




3. Blob Viewer:

* Added syntax highlighting for SQL. This is useful if your
blobs contain SQL queries.

* Added "As BLR" tab. This allows to display the data of
blobs with subtype 2 (for example, RDB$PROCEDURE_BLR of
RDB$PROCEDURES table) as BLR.



4. SP Debugger:

* Fixed problem with ROW_COUNT (Firebird).



5. Script Executive:

* OUTPUT command now supports extracting data into sql-script
as a set of INSERT statements. Two options are available to
control this: ASINSERT and INTO.
Examples of usage:

1. OUTPUT 'C:\MyScripts\Data.sql';
SELECT * FROM MY_TABLE;
OUTPUT;

This will produce a set of following INSERTs:
INSERT INTO MY_TABLE (...) VALUES (...)

2. OUTPUT 'C:\MyScripts\Data.sql';
SELECT * FROM MY_TABLE INTO "MyTable";
OUTPUT;

This will produce a set of following INSERTs:
INSERT INTO "MyTable" (...) VALUES (...)


* Full description of all IBExperts extensions of
script language you can find here:
www.ibexpert.com/rus/IBExpert.phlp.zip

1. Download
2. Unpack
3. Place the IBExpert.phlp into IBExpert directory
4. Restart IBExpert
5. Wait until IBExpert updates the help structure
6. Goto Help tab of Database Explorer and choose
IBExpert/Tools/Script Executive/Script Language Extensions.


Some more Documents can be found here
www.ibexpert.com/documentation


6. Database Restore:

* Added possibility to specify a client library which will
be used while restoring.
Default client library is gds32.dll.


7. Database Designer:

* View editor and Note editor were redesigned. Now they are
not modal.

* Fixed problem with memory leaks while displaying foreign
key marks.

* A lot of bugfixes...


8. Code Editors:

* Added possibility to customize highlighting for
double-quoted string. Use Options | Editor Options |
Colors to cutomize this.

* Added possibility to customize highlighting for
conditional executing directives.

* Code Parameters: now IBExpert displays the list of fields
to be inserted when you type VALUES part of INSERT statements.

* Fixed some problems with Code Insight.


9. View Editor:

* Recreate Script now correctly restores descriptions of
view fields.


10. Main Menu:

* Added Grid menu item. It containts following subitems:

1. Apply best fit.

2. Save grid data as... Saves grid data into TXT, XLS, HTML or
XML formats. This works only with dataset grids (field and
index grids in table editor, parameters/variables grid in
stored procedure editor while working in lazy mode) and
doesn't works with SQL Assistant lists, constraint list
in table editor etc.

3. Copy current record to clipboard. Copies the current record
of any
grid/list into clipboard. Values are delimited with the tab
character.

4. Copy all to clipboard. Copies the content of any grid
(including
column captions) into clipboard. Values are delimited with
the
tab character.


11. IBEScript:

* Added possibility to encrypt/decrypt scripts and to execute
encrypted scripts. There are two way of encrypting possible:

1. Encrypting without the password. In this case there is
no possibility to decrypt an encrypted script but it is
possible to execute this script with IBEscript.

2. Encrypting with the password. In this case it possible to
decrypt the scrypt and execute it with IBExpert if there
is correct password specified.

Next options control the encrypting and decrypting:
-e - encrypts a script and creates a file with extension
"esql" if the output file is not specified.
-d - decrypts the encrypted script if the one was encrypted
with password.
-p<password> - password for encrypting/decrypting
-o<file_name> - output file name


* Current version is 1.76


12. IBEExtract:

* Fixed problem with extracting of exceptions.

* Current version is 1.85


13. Database Comparer:

* Added possibility to stop the process of comparation.


14. User Database:

* Fixed problem with using Firebird Embedded while working
with User Database.


15. A lot of another bugfixes and small improvements...


******************************************************


IBExpert - The most Expert for InterBase and Firebird ---
www.ibexpert.com
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
+49 700 IBEXPERT (42397378)