ANN: New IBExpert Version .62
Holger Klemt
(german version at the end)
============================================================
Here is the weekly newsletter to everybody, who is interested
in the product IBExpert - the most Expert for InterBase.
What´s new?
1.) Today, we uploaded a new version 62 with bugfixes and new features
http://www.ibexpert.com/download
December 20, 2000 (v 1.0.0.62)
1. Project View module was fully rewritten.
Now IBExpert stores Project View data directly
in appropriate database.
Project View allows you to create custom groups
of database objects (tables, procedures etc.)
for more convinient representation of your
database structure. Also you can create User Items
that will contain any kind of text (queries,
procedures texts etc.)
If you do not want to create in your database
additional objects simply don't use Project View.
Before using Project View you should create
three new objects in your database.
To do this in most simple way just execute
the following script:
/* --------- Script begin ---------- */
CREATE TABLE IBE$PROJECT (
IBE$ID INTEGER NOT NULL,
IBE$PARENT_ID INTEGER NOT NULL,
IBE$ITEM_POSITION INTEGER NOT NULL,
IBE$ITEM_NAME VARCHAR(100) NOT NULL,
IBE$ITEM_TYPE SMALLINT NOT NULL,
IBE$DATA BLOB sub_type 0 segment size 100,
IBE$DESCRIPTION BLOB sub_type 0 segment size 100);
ALTER TABLE IBE$PROJECT ADD CONSTRAINT PK_IBE$PROJECT PRIMARY KEY (IBE$ID);
CREATE GENERATOR IBE$PROJECT_ID_GEN;
SET TERM ^ ;
CREATE TRIGGER IBE$PROJECT_BEFORE_DELETE FOR IBE$PROJECT
ACTIVE BEFORE DELETE POSITION 0
AS
BEGIN
DELETE FROM IBE$PROJECT IBEP
WHERE IBEP.IBE$PARENT_ID = OLD.IBE$ID;
END
^
SET TERM ; ^
/* --------- Script end ---------- */
After that you will be able to create folders,
add links to database objects etc.
If you already have some items in your Project View
you may load the project view data from old
format to new one. To do this simple
select 'Load Project View from Old Format' item
in Project View popup menu.
At last you can create folders, add links to
database objects, create user items...
The simpliest way to add links to db objects
is drag-n-drop the appropriate object from
Database Explorer tree. Go to this tree and
select 'Inspector Page Mode' item from popup
menu. After that you will be able to drag-n-drop
items from Database Explorer tree to Project View tree.
Alternatively you may use the Project View popup
menu for this.
2. Added hints for database aliases in DB Explorer.
3. Fixed problems with turning on/off keyboard
templates.
4. Improved handling of 'lost connection' errors while
working with remote servers.
5. SP Debugger: Now stores its size, position, column
widths for variables list and current dock for
debugging results toolwindow.
6. SP Debugger: Added watches. You can select what
variables and parameters you want to see while
debugging. Simple check/uncheck appropriate variables and
parameters in "Parameters and Variables" list and
go to "Watches" page.
7. View Editor: Fixed bug with dependencies.
8. Fixed bug with Service Manager while working
with remote server. Backup/Restore/Database Statistic
now work with remote servers.
9. Fixed bug with sorting of datasets after column
moving.
10. Now it's possible to sort datasets on several columns.
To sort on more than one column hold down Ctrl button,
click on appropriate titles of columns and after
a release of Ctrl key the dataset will be sorted out.
11. DB Explorer: The possibility of custom sorting of
database aliases added. Use drag-n-drop to rearrange
database aliases or use "Reorder databases" item of
popup menu.
12. Table Editor (Fields Page): Information about
primary key fields added.
13. Hyperlinks for quoted identifiers added
(SQL Dialect 3).
14. Some minor bugfixes...
===========================================================
===========================================================
Hier ist die wochentliche Newsletter fur alle IBExpert Anwender
Was ist neu?
1.) Heute haben wir eine neue Version 60 hochgeladen.
http://www.ibexpert.com/download Die Bugfixes finden Sie oben
Das IBExpert Team - ibex...@ibexpert.com
============================================================
HK Software
Lange Straße 59
D-26122 Oldenburg
Germany
Telefon +49 441 2184770
Telefax +49 441 2184779