Dear IBExpert news subscriber, A lot of customers asked us regarding a cheaper possibility to use our ibeblock technology for their own software. The IBExpert VAR License gives a distribution license for all modules including the IBExpert IDE. Some smaller software companies just asked for a way to integrate our technology for a cheaper price. Because we always respect our customers wishes, we created 2 new products: 1. IBEScript EXE Distribution License 2. IBEScript DLL Distribution License The IBEScript Distribution License gives you the unlimited right to integrate IBEScript.exe or IBEScript.dll in your application. you can use it for executing ibeblock scripts that connect to different databases at the same time, integrate any odbc connection as source or destination, simple data import and export, metadata comparison and much more. More examples can be found here http://www.ibexpert.info/documentation/20297.html For using the distribution license, no keys are needed. You do not even need ibexpert full version, but the integrated debugger will help you to develop working scripts. The distribution license contains only the file ibescript.exe or ibescript.dll and the unlimited right to distribute it together with your software. ----------------------------------------------------------------- 1. What is IBEScript EXE? 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. IBEScript.exe can also be used to encrypt script files, so that they are unreadable for the user, but executable together with IBEScript.exe 2. What is IBEScript DLL? 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. 3. What is IBEBLOCK? It is a set of DDL, DML and other statements that are executed on the server and on the client side, and which include some specific constructions applicable only in IBExpert or IBEScript (excluding the free versions of these products), independent of the database server version. With EXECUTE IBEBLOCK you will be able to: * Work with different connections within the single IBEBLOCK at the same time. * Move (copy) data from one database to another. * Join tables from different databases. * Compare data from different databases and synchronize them. * Populate a table with test data using random values or values from other tables or even from other databases or ODBC Connections. * ... and much more. The syntax of IBEBLOCK is similar to that of stored procedures but there are many important extensions. For example: * You can use EXECUTE STATEMENT with any server, including InterBase 5.x, 6.x, 7.x. * You can use one-dimensional arrays (lists) of untyped variables and access them by index. * It isn't necessary to declare variables before using them. * You can use data sets (temporary memory tables) to store data. * ... and much more. 4. Simple ibeblock example to copy data between two databases incl blobs execute ibeblock as begin create connection src dbname 'localhost:c:\src.fdb' password 'repl' user 'REPL' clientlib 'fbclient.dll'; create connection dest dbname 'localhost:c:\dest.fdb' password 'repl' user 'REPL' clientlib 'fbclient.dll'; use src; for select id, usr, ts, sql, idx, dat from ibe$log into :id, :usr, :ts, :sql, :idx, :dat do begin use dest; insert into ibe$log(id, usr, ts, sql, idx, dat) values (:id, :usr, :ts, :sql, :idx, :dat); end use dest; commit; close connection src; close connection dest; end You can execute single IBEBLOCKs via the SQL Editor. You can debug them in the SQL Editor too. They are debugged in the same way as stored procedures and triggers. Also you can include IBEBLOCKs into your scripts and execute these scripts as usual - using the Script Executive or IBEScript.exe. To buy our distribution license products visit our shop at http://www.hk-software.net/h-k.de/content/doc_138099-11-1-00.php and open the product group "distribution license" 5. IBExpert Educational Full Version for only 50 Euro (excl. VAT) For students and teachers at schools or universities, we offer the free IBExpert Educational Version with the 50MB database limit already since a long time. A lot of people already told us that they are very happy with using IBExpert and Firebird in their studies. If they want to use it for larger databases also, they can now get the IBExpert 1 License for Educational Purposes Full License for a special price. This product is not only available for students and teachers at commercial schools or universities. We require the following information for your product registration * User name * User e-mail address * Computer name of the computer, where IBExpert is to be installed. * Copy of the valid school students identity card or Copy of the valid university students identity card or Official order from the School/University We need the copies as scanned email attachments to register@ibexpert.com or fax to +4970042397378 IF WE DO NOT GET THE INFORMATIONS IN READBLE FORMAT, WE WILL NOT BE ABLE TO PROCESS THE ORDER. To buy IBExpert Educational Full Version visit our shop at http://www.hk-software.net/h-k.de/content/doc_138099-11-1-00.php and open the product group "software for educational purposes" The price is 50 Euro. In Germany and Europe we have to charge you additional 8 Euro VAT. When you want to pay by bank transfer, be sure that all transfer fees are paid from the customer, otherwise we can not deliver the product before we receive all the money. We recommend to use paypal. The IBExpert Team Any questions? Ask register@ibexpert.com The most Expert for InterBase and Firebird --- www.ibexpert.com HK Software - Gerhard Stalling Str 47A - 26135 Oldenburg - Germany Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de You receive this email because you have subscribed to get it with IBExpert or IBExpertLive. If you feel you have received this email in error or wish to be removed from this list then simply answer to this email with Subject UNSUBSCRIBE.