IBExpert New Version 2005.03.12 ready for Download

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


IBExpert 2005.03.12
------------------------------------------

1. Blob Editor:

* Added support for PNG (Portable Network Graphics) images.


2. Script Executive:

* Executing of INSERT/UPDATE/EXECUTE PROCEDURE statements
WITHOUT parameters is up to 10 times faster now.

* Added support for following Firebird 2 features:
- CREATE SEQUENCE
- DROP SEQUENCE
- ALTER SEQUENCE

* Fixed problem with sometimes hanging of the Script Executive.

* Extended syntax of OUTPUT command:

1.
output 'E:\data.sql'
as insert into mytable commit after 1000;
select * from IBE$$TEST_DATA where F_INTEGER < 3000;
output;

2.
output 'E:\data.sql'
as reinsert into mytable
commit after 2000;
select * from IBE$$TEST_DATA where F_INTEGER < 3000;
output;

3.
output 'E:\data.sql'
as execute procedure myproc;
select * from IBE$$TEST_DATA where F_INTEGER < 3000;
output;

ASINSERT option is available for compatibility.



3. Table Data Comparer:

* Now works up to 5 times faster.
Many thanks to Nickolay Samofatov for useful hints and
suggestions.


4. Database Comparer:

* Fixed some problems while comparing scripts with following
declarations:
- DECLARE VARIABLE MyVar CHAR;
- WHERE ... CONTAINING
- FOR EXECUTE STATEMENT ...
- EXECUTE STATEMENT ... INTO ...


5. SP/Trigger Editor, SP Debugger:

* Added support for following Firebird 2 features:
- DECLARE <cursor_name> CURSOR FOR ...
- OPEN <cursor_name>
- FETCH <cursor_name> INTO ...
- CLOSE <cursor_name>
- LEAVE <label>
- NEXT VALUE FOR <generator>


6. SQL Editor:

* Fixed problem with displaying of error messages when
executing INSERTEX statements.


7. Data Grid, Input Parameters Window:

* Fixed problem with input of date values when the system date
format
is dd-MMM-yy.


8. Database Designer:

* Added possibility to lock/unlock visual objects to protect them
against casual modifying of size and position.
Use objects context menu to lock/unlock them.


9. IBEBlock:

* SELECT ... EXPORT AS ... implemented.
Examples of usage:

1. SELECT * FROM RDB$FIELDS
EXPORT AS HTML INTO 'E:\TestExport.html'
OPTIONS 'ColorShema=MSMoney; FontFace=Verdana';

Possible ColorShemes are BW, Classic, ColorFull, Gray, MSMoney,
Murky, Olive, Plain, Simple.

2. SELECT * FROM RDB$FIELDS
EXPORT AS XLS INTO 'E:\TestExport.xls' OPTIONS '';

3. SELECT * FROM RDB$FIELDS
EXPORT AS TXT INTO 'E:\TestExport.txt'
OPTIONS 'OmitCaptions';

4. SELECT * FROM RDB$FIELDS
EXPORT AS CSV INTO 'E:\TestExport.txt'
OPTIONS 'OmitCaptions; Delimiter=";"';

5. SELECT * FROM RDB$FIELDS
EXPORT AS XML INTO 'E:\TestExport.xml'
OPTIONS 'Encoding=windows-1251; MemoAsText; StringAsText';


* FOR ... DO loops implemented. Examples of usage:

EXECUTE IBEBLOCK
RETURNS (I INTEGER)
AS
BEGIN
FOR I = 0 TO 100 DO
SUSPEND;
END

It is possible to use CONTINUE statement within FOR loop
to proceed to the next iteration of FOR:

EXECUTE IBEBLOCK
RETURNS (I INTEGER)
AS
BEGIN
FOR I = 0 TO 100 DO
BEGIN
IF (I < 20) THEN
CONTINUE; -- SUSPEND will not be executed
SUSPEND;
END
END


* EXECUTE IBEBLOCK statement implemented. Using this statement
you can call other IBEBlocks from the main block.
Examples of usage:

1.
EXECUTE IBEBLOCK
AS
BEGIN
...
MyFunc = 'EXECUTE IBEBLOCK (
IntVal INTEGER)
RETURNS (
Square INTEGER)
AS
BEGIN
Square = IntVal * IntVal;
END';
EXECUTE IBEBLOCK MyFunc (2) RETURNING_VALUES :Square;
...
END

2.
EXECUTE IBEBLOCK
AS
BEGIN
...
MyFunc = ibec_LoadFromFile('C:\MyBlocks\Square.ibeblock');
EXECUTE IBEBLOCK MyFunc (2) RETURNING_VALUES :Square;
...
END


* Default values and comments for input/output parameters and
variables implemented. Example:

EXECUTE IBEBLOCK (
CodeDir VARCHAR(1000) = 'C:\MyBlocks\' COMMENT 'Path to my
IBEBlocks',
SQLDialect INTEGER = 3 COMMENT 'Database SQL Dialect')
RETURNS (
TotalTime DOUBLE PRECISION = 0 COMMENT 'Total time spent')
AS
DECLARE VARIABLE MyVar INTEGER = 0 COMMENT 'Just a comment'
BEGIN
...
END

Comments for input parameters will be displayed in Description
column
of Request Input Parameters form.
Comments for output variables will be used as column captions of
the result dataset.
Comments for local variables are ignored.


* New examples added:
- ODBC Access
- Table Data Comparer using cursors
- User forms in IBEBlock
Use following URL to download IBEBlock examples:
www.ibexpert.com/download/ibeblockex.zip


10. All console tools (IBEScript, IBECompare, IBEExtract) were
updated.
Current version is 2005.3.12.


11. Many other bugfixes and small improvements...


12. Distribution of IBExpert Modules

* To be allowed to distribute any of the IBExpert Modules
(ibexpert.exe, ibescript.exe, ibescript.dll, ibeextract.exe
and ibecompare.exe) together with your application, you
need:
-IBExpert Site License, if the distribution is located only on
computers in your own company
-IBExpert VAR License, if the distribution is located on
any computer outside your company

If you are already IBExpert customer, you can upgrade to
Site or VAR License and directly buy the 24 month
Extension Product.

See www.ibexpert.com Purchase Area for Details

Some functions of the new IBExpert Modules do not work
on Non licensed Computers, so you can only use them,
where your IBExpert License is valid.

Customers with Site License are allowed to make them
work on every computer in their company just by
copying the License file to the path, where the
module (such as ibescript.exe) should run.

VAR License Customers may also integrate these modules
and the License file in their Software installation.


--
The IBExpert Team

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Gerhard Stalling Strasse 47a - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400