Interbase/Firebird Development
Stuido - version 5.1. Build 5.1.0.280.
NEW FEATURES.
Database Designer:
Database update dialog was redesigned and now using a new comparer
engine. You can check list of changed objects and turn off some of
them from the result script. Version difference can be opened
for edited objects. When you rename/delete any table it is possible
to transfer data to the another one.
Grant Manager. It is possible to set up permissions in the
Database Designer.
Autogrant privileges feature. Allows to automatically issue
privileges for stored procedures, views and triggers.
Data Auditing. Allows to create a special kind of trigger and a
table to audit table changes.
Database Editor:
Database Code Checking.
Autogrant privileges.
Automatic renaming of the table's constraints. Allows to remove
system generated names like "INTEG_xxx".
copy/paste for procedure parameters.
Duplicate Object - an option added to open object editor instead of
immediate saving.
Refactoring and syntax highlighting:
Added ability to automatically create table aliases for select
statement.
Improved data type checking.
Database Comparer:
Redesigned user interface. New comparer engine is using when
comparing two databases which enables to check
dependencies better.
Ability to compare changed objects visually.
FIXED IN THIS VERSION.
Database Designer:
It was possible to create two equal foreign keys in a
diagram.
There was no checking for duplicates when you edit procedure
parameter.
Fixed view order execution when creating new database from the
project.
Database Editor:
SQL Debugger fixed.
Field Editor - data types are sorted alphabetically now.
Not all available character sets was visible.
Comments for local variables were truncated when browsing stored
procedure structure.
Data View - added buttons to manage transaction.
When creating new trigger from the Table Editor the syntax
highlighter has wrong table name thus generates wrong code
completion and shows code errors.