|
NEW FEATURES.
Partial support for Firebird 2.1 implemented. This version supports:
- Database Triggers.
- Domains as datatype for stored procedure parameters.
Database Editor and Database Designer:
- Added support for explicit cursors.
- Added support for EXECUTE BLOCK command.
- Added support for expression based indices.
Database Editor:
- Data View - you can copy selected record as INSERT
command.
- Data View - autorefresh option added with customized refresh
interval.
Database Designer:
- Audit tables can be switched off from the table's list.
FIXED IN THIS VERSION.
Database Comparer:
- Triggers updated more carefully now without dropping them. This
prevents permissions drop and so reduces the size of the script.
Database Editor:
- Fixed exporting data with NULLs to SQL script.
Code Editor:
- You will get a error from SQL parser when you are trying to
select from procedure which has no suspend statement in it. This check
is also performed in the Database Designer before database update.
|
Feature Highlight: checking database code
How can
you be sure that your stored procedures do not contain any dangerous code?
What if you are getting "Arithmetic exception, numeric overflow or
string truncation" with some combination of input parameters? IBStudio has
a solution to eliminate even a possibility for this bugs to exist.
In the Database Editor click "Database" menu and select "Check Database
for code errors":
You will get list
of errors and warnings. Errors may appear
when any of select statement has ambiguous columns (early
versions of InterBase and Firebird do not strongly check your statement
for ambiguity). For the code that can potentially cause above mentioned
exception, IBStudio shows warning. The following screenshot shows the
result of checking Employee database:
|
