VisualCLX patches version 3.8

• VCL application window (don't forget to set the application's title)
• OnEnter/OnExit patch rewritten
• OnActivate/OnDeactivate patch rewritten
• Formular bound patch rewritten
• and many more.

Download Kylix

Version 3.8 (2005-03-26)	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116132) k3patches.3.8.tgz		3rd party compatible
	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116132) k3patches.3.8.tar.bz2		3rd party compatible
Interface incompatible	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116132) k3patchesnc.3.8.tgz		breaks interfaces
	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116132) k3patchesnc.3.8.tar.bz2		breaks interfaces

Download Delphi 7

Version 3.8 (2005-03-26)	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116130) d7clxpatch.3.8.zip		3rd party compatible
Interface incompatible	Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116130) d7clxpatchnc.3.8.zip		breaks interfaces

Download CrossKylix

Version 3.8 (2005-03-26)

Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=135196) ckclxpatches.3.8.zip

3rd party compatible

Download Delphi 6

Version 3.8 (2005-03-26)

Download (http://sourceforge.net/project/showfiles.php?group_id=106820&package_id=116131) d6clxpatch.3.8.zip

breaks interfaces

If you are looking for a Delphi 6 patch that is 3rd party compatible you should have a look at Interface Compatible Unofficial CLX Patches for Delphi 6 (http://www.wpkrenn.net/pmwiki/pmwiki.php/Willi/Delphi6CLX)

Donations (http://unvclx.sourceforge.net/donating.html)

TECT Softwares Stored Procedure Generator (SPGen)

TECT Softwares Stored Procedure Generator (SPGen)
has been designed to create standard procedures for most tables.

Currently SPGen makes no modifications to any database, instead it
creates a script which you can execute against your database.

Pricing:

SPGen is currently in beta and each build is time limited (it will expire after a specified period of time), cost for this product is yet to be determined, however like all our products we will offer the following discounts to Firebird Foundation members, when the product is released:

* Voting Membership - 100% discount.
* Associate Membership - 75% discount.

Beta Test Participation

Beta participation is open to everyone, to get involved simply download a copy of SPGen, all bug reports or feature requests can be submitted directly using our online helpdesk or join our mail list at Yahoo.

VCS 2.40 RC4 server setup released

JVCS team announces the third of the JVCS 2.40 server ports. RC4 introduces support for Oracle10, Firebird characterset configuration possibility, server banner configuration possibility for service ports and a few bug fixes.
For download please navigate to the files section on Sourceforge.

Fyracle 0.8.6 released

Fyracle 0.8.6 released
======================

Changes:

- rewritten error handling
- several fixes and enhancements to the built-in functions
- oracle style '' equals NULL, and NULL equals '' now supported
(only when connected in oracle-mode, of course)
- auto-casting of strings to numerals (i.e. 1 '2') now supported
(only when connected in oracle-mode, of course)
- further fixes to handling of scaled integers
- handling of "insert into ... select ..." fixed

Version 0.8.6 contains fixes for all errors that have been
reported to the Fyracle newsgroup.


Download:

The new runtime installers can be downloaded from:
http://www.fyracle.org/downloads

The developer kit can be downloaded via:
http://www.janus-software.com/fb_buy.html


Upgrade:

The recommended upgrade procedure is to first
uninstall any previous versions of Fyracle and only
then to install the new 0.8.6 release. Remember
to save your configuration files (firebird.conf
and aliases.conf) if you changed them!

The uninstaller has a start menu entry on Windows
and can be found at the top of the install
directory on Linux and Windows.


Compiere:

The current Compiere demo is still 2.5.1g The last
upgrade to these files was on Feb 1st. A port of
Compiere 2.5.2 is underway.

JVCL 3.00 is out!

JVCL 3.00 is out. It is available at SourceForge. We encourage users of JVCL 2.10 to migrate to it as this is the stable release for JVCL 3. Should any bug still be present, please report them in Mantis after having registered a user name.

FlameRobin Unofficial 0.2.4 binaries are out

24.03.2005 -Just like previous releases, packages contain only the binaries and
needed files. No ReadMEs, Installers, Release Notes, Manual, etc. This
is for those who wish to taste the current CVS version without
having to compile everything.
Features:
-a lot of fixes and enhancement of SQL Editor
-many new configuration options (most even work :)
-logging to files works
Known bugs:
- if SELECT statement does not fetch all rows, and you press "Show plan", the error message pops-up. It it (seems) harmless, so you can keep working.
Download: http://www.flamerobin.org/test/0.2.4/

Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS'

So which are the Open Source databases? Most readers have probably heard of MySQL. Its byline is The World's most popular Open Source database after all. There is also PostgreSQL (The World's Most Advanced Open Source Database), as well as Firebird (The Relational Database for the New Millenium). However, there are others too. BerkeleyDB, although not directly comparable, deserves a mention, while Computer Associates recently released Ingres, and IBM did the same to Cloudscape (under the name Derby).

Read more

SQLServer 2005 delayed again

Microsoft has delayed the release date for SQL Server 2005 by about 6 months, perhaps acting on reports of poor high-end performance. A new release of the development tools was delayed as well. Those waiting may use the time to switch to Firebird instead.

Firebird 2.00 Alpha 01

Firebird 2.00 Alpha 01
21 March 2005

The Firebird Project is pleased to announce the release today of the first Firebird 2.0 public Alpha kits for immediate download and testing.

This version of Firebird 2 is an alpha version, meant for field testing only and not for use in production.
All changes and new features are subject to further change and/or
withdrawal in subsequent alpha and beta releases, leading up to final
release. Do not assume that databases created by or upgraded to the on-disk
structure of this alpha will be upwardly compatible with subsequent test
builds/releases.

Bugs, problems, etc. can be posted to the Field Test bug tracker or
to the Firebird Development List.


This release contains a large number of new features, including
derived tables, support for Execute Block, increased table sizes,
new improved index code (the 252-byte index length limit is no longer
applicable), expression indices, numerous optimiser improvements,
enhanced security features, support for on-line incremental backups
along with numerous other improvements and bug fixes. Please read
the Release Notes for more details.


The following builds are currently available, with others to follow soon:
Win32

21-Mar-2005 Windows Installer for Superserver and Classic (3.0 Mb)

21-Mar-2005 Debug build of the above (5.0 Mb)
21-Mar-2005 Embedded Client/Server (zip file, 1.7 Mb)
21-Mar-2005 Debug build of the above (zip file, 3.6 Mb)
21-Mar-2005 Classic and Superserver debug build (zip file, 8.0 Mb)


Linux i686

20-Mar-2005 Linux Classic RPM Installer (2.9 Mb)
20-Mar-2005 Linux Classic, tarball with scripts (2.9 Mb)
20-Mar-2005 Linux Classic debug build, tarball with scripts (18.9 Mb)


Feedback, input and comments re this release will be appreciated, as they will help to speed up the cycle for the full Firebird 2.0 release.



Happy testing!

-- Firebird Project

Praise for Firebird Relational Database

>From: WebHub Technical Support
>Subject: [WebHub-list] off-topic: praise for Firebird Relational Database
>
>"Interbase Deleted, Firebird Installed... Existing Apps Work without Effort"
>
>This is one of those rare stories where software works perfectly, the way
>it should. It's possibly relevant to people on this list so I'll give you
>some details.
>
>I started with a machine running WinNT 4, Interbase (June 2000), 1 WH app
>using a .gdb, 1 other Delphi app using a .gdb. (all on same machine)
>
>I backed up the server. You would have too, if you knew what was planned.
>
>I shut down the apps. I stopped IIS.
>
>I tried to uninstall Interbase but the uninstaller failed, so I stopped
>Interbase in Control Panel > Services, then deleted c:\Program
>Files\Borland\Interbase\*.*.
>
>I found the Firebird 1.5 stable installer here:
>http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_15 ,
>specifically
>
> 25th Dec 2004
> Official
> Windows Setup and Installer For Classic and SuperServer V1.5.2 (.exe) (2.7mb)
> which leads to
>
>http://prdownloads.sourceforge.net/firebird/Firebird-1.5.2.4731-Win32.exe
>
>I ran the installer. Of course I forgot whether I was supposed to choose
>Classic or SuperServer. I found this page
>http://www.firebirdsql.org/manual/qsg15-classic-or-super.html and decided
>on Superserver. NOTE SUPERSERVER IS THE DEFAULT RADIO BUTTON CHOICE. I
>find it easy to remember "use the defaults" ... hint.
>
>I used all the defaults for installation, aside from the folder location
>(used d: ... not c: ...).
>
>The install finished with no errors. I checked Services and Firebird was
>running. So far so good.
>
>I tested the WH app, it worked, no complaints. (Thanks to the TurboPress
>developers for that part.)
>
>I rebooted the machine, it restarted everything including the WebHub App
>and the Delphi app, and BOTH WORKED without any reconfiguration of any sort.
>
>I was so pleased I had to tell you. Best of luck to anyone who tries this
>at home.
>
>Cheers,
>Ann
>

Delphi.NET Running on .NET Compact Frameworks

From Seppy's investigations so far, it's looking very likely that all of the Delphi for .NET language support will work in CF without major modification. He's got the core RTL up and running and is working on fleshing out the rough spots. Using the Delphi language to build WinForms apps on CF is a sure thing.

Read more @

Delphi Compiler Core

Firebird 2 alpha release notes NEW LINK

I hope some of the international language test group coordinators are watching this and can update their links to the Alpha release notes. The link is now

http://xrl.us/fgnj

In case anyone reading this is on the translator team for release notes, please contact me if you are ready to receive the source.

regards
Helen

Improving Query Performance through Index Selectivity

The Firebird query optimizer uses index "selectivity" or "statistics" for selecting the most effective query execution plan.

Read more

Paul Pimblott on JediVCS...

I am a newcomer to JEDI VSC, but have used both sourcesave and more recently
CVS. So far, JEDI is superior in all aspects....

I do have a coupe of questions:

1. I have a project checked in which comprises several folders. When I use
the Source Distribution option, the zip file is not created unless I exclude
the sub folders. Any ideas anyone?

2. Is there an easy way of indicating which modules have been changed on the
main window?

Wonderful software.....

Thanks

Paul

JEDI.NET 1.0 alpha 1 has been released

JEDI.NET 1.0 alpha 1 has been released and can be downloaded from:
http://sourceforge.net/project/showfiles.php?group_id=111655&package_id=147053&release_id=312857.

Besides a source release (containing all sources for the
assemblies, examples and nunit tests) a binary only release is available as well (build against .NET 1.1 and Delphi 2005 update 1; for non-Delphi 2005 owners the Borland.Delphi assembly can be downloaded from http://prdownloads.sourceforge.net/jedidotnet/Borland.Delph_2k5-SP1.zip?download; you'll need to install it into the GAC or put it in the main/bin and main/examples/bin folders).

In addition, two help files are available, one as a .chm file and
one in Help2 format. You can also browse the help on line at http://jedidotnet.sourceforge.net/help/index.html.

IBExpert Version 2005.03.16

IBExpert Version 2005.03.16 FULL is available for download.

Now supports many Firebird 2 features
Increased speed of Script Executive and Table Data Comparer
New IBEBlock commands

FastReport 3.11

FastReport 3.11
03/14/2005

+ added Greek resources
+ added HTML tags support in PDF export
+ added Hebrew, Turkish and Arabic languages in the PDF export filter
+ added property TfrxPDFExport.Background (default = False)
+ added properties TfrxRTFExport.Creator and TfrxPDFExport.Creator
+ improved quality of the PDF export filter
+ password protected reports is now working in client/server mode
(IMPORTANT: Do not use this feature in one time with the server authentification)
+ verbose output of the server errors in the HTML mode
- fixed name of the properties TfrxServerConnection.Proxy and TfrxServerConnection.ProxyPort
(press 'ignore' button on load prompt in yours projects for autofix form components)
- fixed clean of the report cache on TfrxReportServer.Stop method
- fixed background draw in HTML export filter in server mode
- many bug fixes
Download...

SQLDirect Component Library V4.2.1

SQLDirect Component Library V4.2.1 is now available.

IBReplicator V2.1.1available

IBReplicator V2.1.1 is available for download. This release fixes a problem where reloading the configuration database can cause unpredictable behaviour for the event listener.

InterBase/Firebird DB Comparer V1.3

EMS announce the availability of V1.3 of their InterBase/Firebird DB Comparer.