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

3750 questions
17
votes
7 answers

Combining UNION ALL and ORDER BY in Firebird

Using Firebird, I want to combine the results of two queries using UNION ALL, then sort the resulting output on a given column. (select C1, C2, C3 from T1) union all (select C1, C2, C3 from T2) order by C3 The parentheses came from valid syntax…
Chris
  • 1,400
  • 1
  • 10
  • 14
17
votes
4 answers

Best method to secure connection to firebird over internet

I have a client-server application which use a firebird server 2.5 over internet. I have met the problem of given a secure access to FB databases and as a first approch a tried to solve this problem by integrating a tunnel solution in the…
moualek adlene
  • 171
  • 1
  • 3
17
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
  • 6,395
  • 5
  • 38
  • 50
16
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
  • 171
  • 1
  • 4
16
votes
2 answers

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
  • 686
  • 3
  • 9
  • 21
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…
Freddie Bell
  • 2,186
  • 24
  • 43
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
  • 1,013
  • 1
  • 10
  • 21
14
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
  • 16,949
  • 65
  • 235
  • 452
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,392
  • 4
  • 42
  • 62
14
votes
1 answer

Easiest way to create an auto increment field in Firebird database

Is there an easy way to create auto increment field using Firebird? I have installed the FlameRobin admin tool, but the process of creating an auto increment field through the tool is complex. Can I not create such an identity field just by clicking…
gomesh munda
  • 838
  • 2
  • 14
  • 32
14
votes
3 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
  • 8,537
  • 7
  • 33
  • 46
14
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,337
  • 2
  • 32
  • 44
13
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…
Desolator
  • 22,411
  • 20
  • 73
  • 96
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
13
votes
2 answers

Is it possible to rename a table in Firebird?

Is it possible to rename a table in Firebird or I should create a new table and then move the data using insert?
zac
  • 4,495
  • 15
  • 62
  • 127
1
2
3
…
99 100