ANN: Top Ten Reasons why you need IBExpert Developer Studio VAR License


2006-04-05 06:51:22 AM
delphi274
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 De{*word*81} 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 XXXX@XXXXX.COM:
-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 XXXX@XXXXX.COM 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 - XXXX@XXXXX.COM - www.h-k.de