Hi,

A bit OT, but as other methods to contact you did not work for some time
now I give this a try.

Just tried again to get the personal version, actually the password from
this page:
http://www.ibexpert.biz/ibewebforms/?license=hk&id=Download

I have tried this for many month now, I also reported my problem to the
email as requested on that page but to no avail.

Best regards
Werner

P.S. I used this email address to get the password

HKlemt wrote:

> IBExpert New Version 2007.05.03 ready for Download
>
> Today we uploaded a new Version 2007.05.03
> of IBExpert on www.ibexpert.com
>
> What is new?
>
> 1. Support of new keywords of FB 2.1
> 2. Copy Database Object feature implemented.
> 3. Database Designer Colors
> 4. Index Editor
> 5. IBEBlock
> 6. A lot of minor bugfixes and small improvements...
> 7. German Firebird Training Program
> 8. International On Site Performance Suport
>
> and much more ...
>
> If you are registered customer and cannot access the
> customer area, please check the update end date from=20
> your registration form.
>
> If you update right is already expired,you can extend=20
> it for the next two years with buying the Extension=20
> license(s) in our shop. See details on our Web Site
> www.ibexpert.com or just ask register@...=20
> for details.
> ------------------------------------------
>
>
> IBExpert 2007.05.03
> ------------------------------------------
>
> 1. Support of new keywords of FB 2.1
>
> 2. Copy Database Object feature implemented.
> This feature is available from Main Menu | Tools
> and also from the Database Explorer context menu.
>
> Copy Database Object feature is based on IBEBlock
> functionality and therefore is fully customizable.
>
>
> 3. Database Designer:
>
> * Custom Colors are saved and restored in/from a grc-file now.
>
>
> 4. Index Editor:
>
> * Added possibility to define index description.
>
> 5. IBEBlock:
>
> * New concatenating assignment operator - '.=3D' - appends the
> argument on the right side to the argument
> on the left side.
> Example: sVal =3D 'abc';
> sVal .=3D 'def' Now sVal is equal to 'abcdef';
>
>
> * ENUM datatype implemented.
> Mostly this datatype is useful for input parameters when it is
> necessary to
> allow users to select a value from a given set of values.
> execute ibeblock (MonthName enum ('January', 'February', 'March',
> 'April', 'May', 'June', 'July',
> 'August', 'September', 'October',
> 'November', 'December') default =3D 0=
> )
> as
> begin
> ...
> end;
>
> For each input parameter of type ENUM IBExpert will create a
> combobox with
> corresponding set of items.
> See Copy Database Object blocks to learn how this works.=20=20=20
> * ibec_preg_match function.
>
> Syntax:
> function ibec_preg_match(Pattern : string; Subject : string [;
> Matches : array of variant) : boolean;
> ibec_preg_macth function searches Subject for a match to the
> regular expression given in Pattern.
> Returns TRUE if a match for Pattern was found in the Subject
> string, or FALSE if not match was found or an error occurred. =
> =20
> If Matches is provided, then it is filled with the results of search.
>
> Following example returns list of all e-mail addresses used in a
> text file:
>
> execute ibeblock returns (
> Email varchar(200))
> as
> begin
> s =3D ibec_LoadFromFile('C:\SomeData.txt');
> sPattern =3D '([_a-zA-Z\d\-\.]+@[_a-zA-Z\d\-]+(\.[_a-zA-Z\d\-]+)+)';
> ibec_preg_match(sPattern, s, aEmails);
> foreach (aEmails as Email skip nulls) do
> suspend;
> end
> Learn more about syntax of regular expressions available in
> IBExpert:
> http://www.ibexpert.info/documentation/263067.html
> =20=20=20
> * ibec_preg_replace function.
> Syntax:
> function ibec_preg_replace(Pattern : string; Replacement : string;
> Subject : string) : string;
> ibec_preg_replace function searches Subject for matches to
> Pattern and replaces them with Replacement. If matches are
> found, the new Subject will be returned, otherwise Subject will be
> returned unchanged.=20
> Following example removes all IB comments (/*...*/) from a text:
> execute ibeblock
> as
> begin
> s =3D ibec_LoadFromFile('C:\SomeScript.sql');
> sPattern =3D '/\*/*([^/]*\*+)+/';
> s =3D ibec_preg_replace(sPattern, '', s);
> ibec_SaveToFile('C:\ScriptNoComments.sql', s, __stfOverwrite);
> end
>
> Learn more about syntax of regular expressions available in IBExpert:
> http://www.ibexpert.info/documentation/263067.html=20=20=20=20
>
> * FOREACH statement now has new option - SKIP NULLS
>
> Syntax:
> FOREACH (var1 AS var2 [KEY | INDEX var3] [SKIP NULLS]) DO
> <statements>
> FOREACH statement with SKIP NULLS option is equal to following
> FOREACH statement without SKIP NULLS option:
>
> FOREACH (var1 AS var2 [KEY | INDEX var3]) DO
> BEGIN
> IF (var2 IS NULL) THEN
> CONTINUE;
> <statements> END
> =20=20=20
>
> * ibec_GetUsers function implemented.
> This function retrieves list of users from the server using the
> Services Manager.
>
> Syntax:
>
> function ibec_GetUsers(ConnectOptions : string; UserNames :
> variant [; FullData : variant]) : variant;
>
> ibec_GetUsers returns NULL if no error occured, otherwise it
> returns an error message.
> UserNames Following example returns a list of users
> registered on the server:
>
> execute ibeblock
> returns (UserName varchar(100),
> FirstName varchar(100),
> MiddleName varchar(100),
> LastName varchar(100))
> as
> begin
> res =3D ibec_GetUsers('Server=3Dlocalhost/3065; User=3DSYSDBA;
> Password=3Dmasterkey;
> ClientLib=3DC:\Program
> Files\Firebird\Bin\fbclient.dll',
> UserNames, FullData);
> foreach (UserNames as UserName key UserIdx) do
> begin
> s =3D FullData[UserIdx];
> ini =3D ibec_ini_Open('');
> try
> ibec_ini_SetStrings(ini, s);
> =20
> FirstName =3D ibec_ini_ReadString(ini, 'UserData',
> 'FirstName', '');
> MiddleName =3D ibec_ini_ReadString(ini, 'UserData',
> 'MiddleName', '');
> LastName =3D ibec_ini_ReadString(ini, 'UserData', 'LastName', '')=
> ;
> finally
> ibec_ini_Close(ini);
> end;
> suspend;
> end
> end
>
>
> 6. A lot of minor bugfixes and small improvements...
>
>
> 7. German Firebird Training Program
> **************************************************************
> *German Firebird Training Program *
> *11-20 June 2007 *
> * *
> *The next German-language Firebird Training courses are being*
> *held in Wardenburg, North Germany. Course details can be *
> *found on http://www.h-k.de/fbct *
> **************************************************************
>
> **************************************************************
> *Firebird Schulungsprogramm *
> *11.-20. Juni 2007 *
> * *
> *Das n=E4chste deutschsprachige Firebird Training findet im *
> *Juni in Wardenburg, Norddeutschland statt. Details dazu *
> *Sie unter http://www.h-k.de/fbct *
> *Themen: *
> *1. Firebird: Grundlagen fur Entwickler *
> *2. Firebird: Grundlagen fur Datenbankadministratoren *
> *3. Firebird: Leistungssteigerung und Optimierung *
> *4. Datenbankportierung von BDE, IB, Paradox, dBase und MS *
> * Access auf Firebird *
> *5. Datenbankauswertungen mit Firebird und Fastreport *
> *6. Dynamische Webanwendungen mit Firebird und PHP *
> **************************************************************
>
> 8. International On Site Performance Suport
>
> Do you have some tasks which need a review by database=20
> performance experts?=20
>
> -Do you really know that there are no blocking transactions?=20
> -Is the garbagecollector really successful?=20
> -Is the database design as good as it can be?
> -Will additional indices increase or decrease performance?
> -Are changes on existing indices needed?=20
> -Do the Stored Procedures/Triggers/Views use the indices?
> -Which are the bottleneck sql statements in your application?
> -How to optimize SQL statements for specific jobs?
>
> All this questions can be answered by the IBExpert Team.=20
>
> *************************************************************
> One/Two day on site Performance Workshop:
>
> A very experienced IBExpert employee will review your system=20
> in your production environment and improve your options and=20
> environment. A code review might also give some hints to=20
> your development team. This workshop will take between one=20
> and two days. Languages english or german.
>
> Pricing with individual traveling costs can be asked from=20
> info@....=20
>
> This service is worldwide avilable!
> *************************************************************
>
> The IBExpert Team
>
> The most Expert for InterBase and Firebird --- www.ibexpert.com
> HK Software - Oldenburger Str 233 - 26203 Wardenburg - 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.
>
>
>
>
>
> =20
> Yahoo! Groups Links
>
>
>
>