Top Ten Reasons why you need IBExpert Developer Studio VAR License

IBExpert gives you

1. IBEBlock technology to create procedures with access to data in
different FB/IB
databases
2. ODBC access to all ODBC datasources for importing or exporting data
from a script
3. Comparing databases from scripts
4. Datawarehouse OLAP Cube Data Analysis
5. File import into blobfields from SQL scripts
6. IBExpert IDE to develop and test
7. IBEscript.exe to execute all IBEBlock scripts in batchfiles
8. IBEscript.dll to execute all IBEBlock scripts from your own application
9. Userdefined menu to disable unwanted menuitems in the IBExpert IDE
10.VAR license for bundling IBExpert together with your application

Details:

----------------------------------------------------------------------------
1. IBEBlock Technology to create procedures with access to data in
different FB/IB
databases

A simple script to copy data from one FB/IB database to another:

execute ibeblock
as
begin
FBSrc =
ibec_CreateConnection(__ctFirebird,'DBName="localhost:C:\DB1.FDB";
ClientLib=C:\Program Files\Firebird\Bin\fbclient.dll;
user=SYSDBA; password=masterkey; names=WIN1252; sqldialect=3');
FBDest =
ibec_CreateConnection(__ctFirebird,'DBName="localhost:C:\DB2.FDB";
ClientLib=C:\Program Files\Firebird\Bin\fbclient.dll;
user=SYSDBA; password=masterkey; names=WIN1252; sqldialect=3');
ibec_UseConnection(FbSrc);
for select CustNo, Company, Addr1 from customer order by company into
:CustNo, :Company,
:Addr1
do
begin
use FBDest;
INSERT INTO CUSTOMER (CustNo, Company, Addr1) VALUES (:CustNo,
:Company, :Addr1);
use FBSrc;
end
use FBDest;
COMMIT;
ibec_CloseConnection(FBSrc);
ibec_CloseConnection(FBDest);
end
----------------------------------------------------------------------------
2. ODBC access to all ODBC datasources for importing or exporting data
from a script

The same can also be done with any ODBC datasource as the source
and/or destination:

execute ibeblock
as
begin
OdbcCon = ibec_CreateConnection(__ctODBC, 'DBQ=C:\demo.mdb;
DRIVER=Microsoft Access
Driver (*.mdb)');
FBCon =
ibec_CreateConnection(__ctFirebird,'DBName="AVX-MAIN:D:\FB2_DATA\IBEHELP.FBA";
ClientLib=C:\Program Files\Firebird\Bin\fbclient.dll;
user=SYSDBA; password=masterkey; names=WIN1251; sqldialect=3');
ibec_UseConnection(OdbcCon);
for select CustNo, Company, Addr1 from customer order by company into
:CustNo, :Company,
:Addr1
do
begin
use FBCon;
INSERT INTO CUSTOMER (CustNo, Company, Addr1) VALUES (:CustNo,
:Company, :Addr1);
use OdbcCon;
end
use FBCon;
COMMIT;
ibec_CloseConnection(OdbcCon);
ibec_CloseConnection(FBCon);
end
----------------------------------------------------------------------------
3. Comparing databases from scripts

The following script compares the structure of two IB/FB databases and
stores
a script that can be used to synchronize the database structure in the
destination
database:

execute ibeblock
as
begin
create connection MasterDB dbname 'localhost:c:\MasterDB.fdb'
password 'masterkey' user 'SYSDBA' sql_dialect 3
clientlib 'C:\Program Files\Firebird\bin\fbclient.dll';

create connection CustDB dbname 'localhost:c:\CustDB.fdb'
password 'masterkey' user 'SYSDBA' sql_dialect 3
clientlib 'C:\Program Files\Firebird\bin\fbclient.dll';

cbb = 'execute ibeblock (LogMessage variant)
as
begin
ibec_progress(LogMessage);
end';

ibec_CompareMetadata(MasterDB, CustDB, 'C:\CompRes.sql',
'OmitDescriptions; OmitGrants', cbb);

close connection MasterDB;
close connection SubscriberDB;
end
----------------------------------------------------------------------------
4. OLAP Cube Data Analysis

IBExpert can be used to create OLAP Cubes. The viewer can be found in Menu
Tools - Data Analysis.

execute ibeblock
as
begin
SelectSQL = 'select rf.rdb$relation_name, f.rdb$field_type,
f.rdb$field_length, f.rdb$field_precision
from rdb$relation_fields rf, rdb$fields f
where rf.rdb$field_source = f.rdb$field_name';
vDimensions[0] = 'FieldName=RDB$RELATION_NAME; Alias="Table Name"';
vDimensions[1] = 'FieldName=RDB$FIELD_TYPE; Alias="Field Type';
vMeasures[0] = 'FieldName=RDB$FIELD_TYPE; Alias="Field Count";
CalcType=ctCount;
Format=0';
vMeasures[1] = 'FieldName=RDB$FIELD_LENGTH; Alias="Total Length";
CalcType=ctSum;
Format=0';
vMeasures[2] = 'FieldName=RDB$FIELD_PRECISION; Alias="Avg Precision";
CalcType=ctAverage';
ibec_BuildCube('C:\test_cub.cub', SelectSQL, vDimensions, vMeasures,
null);
end
----------------------------------------------------------------------------
5. File import into blobfields from SQL scripts

The following script imports the data from the files into the table test:

SET BLOBFILE 'C:\f1.jpg';
INSERT INTO TEST(ID,BLOBCOL) VALUES (1, :h00000000_7FFFFFFF);
SET BLOBFILE 'C:\f2.jpg';
INSERT INTO TEST(ID,BLOBCOL) VALUES (2, :h00000000_7FFFFFFF);
SET BLOBFILE 'C:\f3.jpg';
INSERT INTO TEST(ID,BLOBCOL) VALUES (3, :h00000000_7FFFFFFF);

The same syntax can be used for updating the blobdata
----------------------------------------------------------------------------
6. IBExpert IDE to develop and test

IBExpert is a professional Integrated Development Environment (IDE)
for the
development and administration of InterBase 4.X-7.X and Firebird 1.X-2.X
databases. Whether you enjoy the control of hand-coding DML or DDL
statements or working in a visual editing environment, IBExpert makes it
easy to get started and provides you with vital tools to speed and
enhance
your work.

IBExpert includes many coding tools and features: visual editors for all
Database Objects, an SQL Editor and Script Executive, a Debugger for
stored procedures and triggers, a Query Builder, a powerful Database
Designer and much more...

IBExpert's visual editing features allow even the total beginner to
quickly
create a database and add database objects without writing a single line
of code. You can view, navigate and work on all your database objects in
the IBExpert DB Explorer.

IBExpert is the most comprehensive GUI tool for Firebird and InterBase
on the market today.
----------------------------------------------------------------------------
7. IBEScript.exe to execute all IBEBlock scripts in batchfiles

IBEScript.exe can be used to execute any valid IBExpert script in
batchfiles. For example a scheduled import or export job can be
started without the need of any user input.

IBExpert can also be used to encrypt script files, so that they are
unreadable for the user, but executable together with IBEScript.exe
----------------------------------------------------------------------------
8. IBEscript.dll to execute all IBEBlock scripts from your own application

When you want to integrate IBExperts scripts in your own application,
you can use IBEScript.dll. A simple example for Delphi can be found
in IBExperts IBEScriptDll subdirectory. It can also be used from all
other programming languages that can handle DLL calls.
----------------------------------------------------------------------------
9. Userdefined menu to disable unwanted menuitems in the IBExpert IDE

You want to give your customer access to some of the functions in the
IBExpert IDE? For example
-the Reportmanager to execute, design and print reports
-the Data Analysis tool to open and analyze OLAP Cube Files
-the Backup and Restore menu

No problem, just place a file with the name ibexpert.usr and the
following content in the directory where ibexpert.exe is:

execute ibeblock
as
begin
ibec_DisableFeature(0) --disable all
ibec_EnableFeature(1003); --enable Tools menu
ibec_EnableFeature(2148); --enable menuitem tools-data analysis
end

The numbers needed to enable features can be found in the menu
Translate IBExpert. Using the number 0 means a wildcard to disable
all functions.
----------------------------------------------------------------------------
10.VAR License for bundling IBExpert together with your application

The IBExpert Value Added Reseller Version is for software companies, who
like to bundle IBExpert with their software. Here we offer a new model
to integrate IBExpert.

You are not a software company, but you want to use IBExpert on
all computers in your company? In this case the Site License is
the right choice.

SPECIAL OFFER:

Only valid with payment by invoice and wiretransfer to german
bank account or paypal account register@...:

-VAR License = 1790 Euro (regular 2190 Euro)
Advantages: all modules can be used on all computer in your
company and also on your customers computers, where your
Software is installed, no computer specific keys needed)

-Site License = 1250 Euro (regular 1450 Euro)
Advantages: all modules can be used on all computer in your
company, no computer specific keys needed)

The Offer is only valid until 15th April 2006.
Interested? contact register@... for ordering
----------------------------------------------------------------------------
The Firebird and IBExpert Database Workshop

22nd - 26th May 2006, Palma de Mallorca, Spain

This year's Database Workshop will take place at the
Hotel Horizonte in Palma de Mallorca, Spain, from 22nd
to 26th May 2006.

Arrival is planned on Saturday 20th, departure is planned
on Saturday 27th. If you wish to attend the workshop,
please fill out the registrationfax (download from
www.h-k.de/dbws) and send it by fax to +49 700 4239 7378:
----------------------------------------------------------------------------
The most Expert for InterBase and Firebird - www.ibexpert.com
HK Software - 26135 Oldenburg - Germany - info@... - www.h-k.de