Stack Overflow
Stack Overflow

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

3372 questions
16
votes
6 answers

Combining UNION ALL and ORDER BY in Firebird

This is my first attempt at answering my own question, since someone may well run into this and so it might be of help. Using Firebird, I want to combine the results of two queries using UNION ALL, then sort the resulting output on a given column.…
Chris
  • 1,380
  • 1
  • 10
  • 14
16
votes
3 answers

How to make Firebird client application wait for row to unlock

My familiarity is with the Microsoft SQL server world using ADO (dbGo), and I have written many applications for that environment. Now I have a legacy Delphi 7 application with a Firebird 2.5 database that I must maintain. BUT I am finding is that…
nolaspeaker
  • 1,868
  • 19
  • 38
15
votes
5 answers

How do I explicitly insert nulls into a parametized query?

I'm using Delphi 7 and Firebird 1.5. I have a query that I create at runtime where some of the values might be null. I can't work out how to get Firebird to accept explicit nulls for values that I need to leave as null. At this stage I'm building…
Мסž
15
votes
6 answers

Which embedded database has maximum SQL compliance, and concurrency support?

My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users). I also require that the…
vikramsjn
  • 921
  • 1
  • 9
  • 21
14
votes
0 answers

Custom transaction level in Delphi DBX firebird

I am looking for a way to specify a custom transaction level in Delphi's DBX using the firebird driver. I am using Delphi XE. In the Parameter editor of the TSQLConnection component I can set various TransIsolation values and I'm using the default…
Ronald
  • 151
  • 1
  • 4
14
votes
3 answers

Does Firebird need manual reindexing?

I use both Firebird embedded and Firebird Server, and from time to time I need to reindex the tables using a procedure like the following: CREATE PROCEDURE MAINTENANCE_SELECTIVITY ASDECLARE VARIABLE S VARCHAR(200); BEGIN FOR select RDB$INDEX_NAME…
pablo
  • 6,282
  • 3
  • 39
  • 59
14
votes
1 answer

Why do I get an unsupported on-disk structure error when opening a Firebird database?

I'm trying to open a .fdb (Firebird) database using FlameRobin but it is giving me the following error message: *** IBPP::SQLException *** Context: Database::Connect Message: isc_attach_database_failed SQL Message: -820 wrong or obsolete…
cosmarchy
  • 638
  • 2
  • 8
  • 20
14
votes
4 answers

How can I get the table description (fields and types) from Firebird with dbExpress

I have written a tool for displaying database structures using the GetTableNames and GetFieldNames methods of TSQLConnection. How can I get the types of each field name similar to the following list (which is part of the DDL required to build the…
No'am Newman
  • 5,936
  • 5
  • 33
  • 48
13
votes
8 answers

Which Freeware "GUI tool" for "Firebird RDBMS" closestly resembles "MS SQL Server 2000 Management Studio"?

Which Freeware "GUI tool" for "Firebird RDBMS" closestly resembles "MS SQL Server 2000 Management Studio"?
user366312
  • 17,582
  • 55
  • 198
  • 392
13
votes
1 answer

Why does Firebird truncate decimal places when dividing?

Firebird truncates decimal places when dividing, rather than rounding. Furthermore, it bases the number of decimal points in the returned value on the number of decimal places in the numerator and denominator. Why is Firebird truncating instead of…
Ray Zane
  • 236
  • 1
  • 4
  • 10
12
votes
4 answers

What are the advantages of VistaDB

I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. I have never had a reason to consider it. What are the benefits of paying for VistaDB vs using another technology? Things I have thought…
Andrew Burns
  • 12,329
  • 9
  • 36
  • 40
12
votes
4 answers

How to connect and use Firebird db embedded server with Visual C# 2010

I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what I done till now: Downloaded Firebird .Net Data Provider (Firebird Client v2.5.2). Downloaded Firebird Embedded server (Firebird Embedded Server…
SolidSnake
  • 20,635
  • 18
  • 68
  • 89
12
votes
3 answers

How to maintain a transitive closure table efficiently?

I have a DAG in my relational database (Firebird) with two tables edge and node (adjacency list model). I want to query them recursively, but found recursive queries very inefficient. So I tried to implement triggers to maintain the transitive…
Christoph Walesch
  • 2,129
  • 2
  • 33
  • 44
11
votes
6 answers

Firebird connection with java

I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code: Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager.getConnection( …
Rakesh Goyal
  • 2,947
  • 6
  • 33
  • 65
11
votes
2 answers

Get list of column names from a Firebird database table

How do you get a list of the column names in an specific table? ie. Firebird table: | name | id | phone_number | get list like this: columnList = ['name', 'id', 'phone_number']
jramirez
  • 7,963
  • 6
  • 29
  • 45
1
2
3
…
99 100