logo header
 НОВОСТИ  |  СКАЧАТЬ  |  ЛИЦЕНЗИЯ  |  ПОДДЕРЖКА  |  КОНТАКТЫ 

Interbase/Firebird Development Stuido - version 5.1. Build 5.1.6.350.

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:


SQLLY Development, 1999-2007, support@sqlly.com