Firebird – unique index vs. unique constraint
From time to time I got a question about the difference between unique key and unique constraint.
From time to time I got a question about the difference between unique key and unique constraint.
Hi all,
This is mostly a bug-fix release, probably a first ‘stable’ 0.8
version without major bugs. Windows, Linux and Mac OS X binaries and
source code package are available for download. I recommend all Linux
distribution packagers to upgrade (especially if you still use 0.8.3
or lower). Here’s the changelog since 0.8.3:
New features
– DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
– DataGrid: A basic ORDER BY clause building when column header is
double-clicked
– Support for LIST function in Firebird 2.1
– Support for MON tables in Firebird 2.1 (Read-only for now.)
Enhancements and Bug fixes
– DataGrid: FR no longer crashes when transaction has ended
(commit/rollback) and grid edit control is active
– DataGrid: Complete string is now shown for editing and copying multiline text
– DataGrid: Copy command now copies a single cell if nothing is selected
– DataGrid: Fixed mixup between BLOB ID and data it contains
– DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
– DataGrid: Successfully deleted rows are deselected, so user can
easily see what is done.
– DDL extraction for GRANTs now only quotes names when needed
– DDL extraction for defaults does not use double quotes anymore.
– Database property page now shows minor ODS version when it is not zero
– Hovering over icons in privileges window, now really shows the grantor
– Improved parsing of SELECT statements
– Support for INSERT..RETURNING and EXECUTE STATEMENT that return a
single record
– Fixed messagebox flood when Execute Procedure called and it doesn’t
return anything
– Print preview and SaveToHtmlFile works again for manual and changelog
– Extracting invalid DDL (missing domain data in system tables) does
not crash FR anymore
– Silent installation (on Windows) does not show changelog window anymore
– Autogenerated domains (system domains) do not show up in the tree anymore
– Added ALTER DOMAIN action for domains
– Tree now shows NOT NULL for columns that inherit NOT NULL from domain
– Fixed parsing bug when non-reserved keyword is used as identifier
– Fixed autocomplete for selectable procedure alias when procedure
call contains parameters (in PSQL)
Enjoy.
The new version of FirebirdClient (ADO.NET Data Provider) is available for download: http://firebirdsql.org/index.php?op=files&id=netprovider .
It’s mainly a bugfix release. Work on Entity Framework support still continues.
From Carlos Guzmán Álvarez:
I have decided to leave the project, the reason is mainly that i have left to do development in my spare time and really i’m going to continue in that situation for a long time, really, right now the last thing i want when i reach home is get coding again
I want to give great thanks to all of you for your help and support in all the time i was active in the development of the .NET provider 🙂
Installing Firebird DDEX provider into Visual Studio 2005 on Windows Vista (64-bit). Nothing brand new, but can help begginers when trying to use Firebird in .NET and in VS.
A simple way how to store GUID in Firebird (not only from .NET). Read here.
FirebirdClient v2.1.0 Release Candidate 1, ADO.NET Data Provider for
Microsoft .NET 2.0, and mono is available for download.
Download information can be found here:
http://www.firebirdsql.org/index.php?op=files&id=netprovider
The Firebird team is pleased to announce the latest Firebird 2
sub-release, V.2.0.1. Binary and source kits for Linux and Windows
have begun to appear at the Sourceforge mirrors today. Details all at
www.firebirdsql.org.
The Firebird Project Team
FirebirdClient v2.1.0 Beta 2, ADO.NET Data Provider for Microsoft .NET
2.0, and mono is available for download.
Download information can be found here:
http://www.firebirdsql.org/index.php?op=files&id=netprovider