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
7
votes
2 answers

Can't declare variable in Firebird 2.5, why?

I have a one line query: DECLARE VARIABLE var_SecondsOfTime INTEGER; But after running the query I am getting this message: Engine Error (code = 335544569): Dynamic SQL Error. SQL error code = -104. Token unknown - line 1, column 9.…
Wodzu
  • 6,932
  • 10
  • 65
  • 105
7
votes
3 answers

FDQuery causing Out of memory exception

I have a Firebird database with 3 million records. My FetchOptions are RowsetSize := 1000 with FetchAll disabled. I work on localhost. I have no problem browsing page by page, but when I click on "goto last record" button in the DBNavigator, it…
Niyazi Korkmaz
  • 71
  • 1
  • 4
7
votes
2 answers

How to use DISTINCT ON (of PostgreSQL) in Firebird?

I have a TempTable with datas: ------------------------------------ | KEY_1 | KEY 2 | NAME | VALUE | ------------------------------------ | 1 | 0001 | NAME 2 | VALUE 1 | | 1 | 0002 | NAME 1 | VALUE 3 | | 1 | 0003 | NAME 3 | VALUE…
Fox Vĩnh Tâm
  • 150
  • 1
  • 2
  • 15
7
votes
2 answers

VC++ Exception Handling differ on x86 and x64 for IBPP / Firebird client

I am hacking around with IBPP on Visual Studio 2015 / VC++. IBPP is a c++ wrapper for the firebird / interbase API. IBPP, a C++ Client Interface to Firebird Server Part of this package is a little test-suite, you may download it…
cmks
  • 527
  • 2
  • 11
7
votes
2 answers

Firebird .NET provider and embedded server 3

I'm trying to use .NET Firebird Provider to connect to the embedded FB 3.0.1 server. As far as I know, (also written here (page 6)), there is no more fbclient.dll\fbembed.dll but a single client fbclient.dll used for remote and embedded access. But…
Barzo
  • 1,039
  • 1
  • 11
  • 37
7
votes
2 answers

How to resolve Firebird "unavailable database" error on a remote database?

I have a Firebird 2.0 database running on a remote Windows XP PC. Using the ADO.net connection provider, I configure the connection as follows: Dim x As New FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder x.Database =…
Frosty840
  • 7,965
  • 12
  • 50
  • 86
7
votes
2 answers

Firebird Cursors - Why would you use one

In the documentation here, the following code example is given for using a cursor: execute block returns ( relation char(31), sysflag int) as declare cur cursor for (select rdb$relation_name, rdb$system_flag from rdb$relations); begin open…
Paul
  • 5,700
  • 5
  • 43
  • 67
7
votes
3 answers

How To Get Entire Linked Group Details using SQL?

In have table called "MYGROUP" in database. I display this table data in tree format in GUI as below: Vishal Group | |-------Vishal Group1 | |-------Vishal Group1.1 | |-------Vishal Group1.1.1 | |-------Vishal Group2 | …
Vishal Tiwari
  • 739
  • 2
  • 12
  • 28
7
votes
1 answer

Entity Framework suggest invalid field name

I have two tables in my DataBase, BUNTS, which contains information about pieces of steel CREATE TABLE BUNTS ( BUNTCODE INTEGER NOT NULL, BUNTNAME VARCHAR(20), BUNTSTEEL INTEGER, ...... ); and…
Pallaris
  • 71
  • 4
7
votes
2 answers

SQL query joining tables from different fdb databases

I have 2 fdb databases company.fdb and timeAtt.fdb company.fdb contains staffDetail table staffId - 001 staffName - Andy staffStatus - Active timeAtt.fdbcontains staffAtt table staffId - 001 staffName - Andy timeIn …
WaN
  • 91
  • 3
  • 9
7
votes
0 answers

Jaybird 2.2.4 NestedTransactionNotSupportedException: JpaDialect does not support savepoints

Using @Transactional(value ="erpJPA",propagation=Propagation.NESTED ) i have the exception Caused by: org.springframework.transaction.NestedTransactionNotSupportedException: JpaDialect does not support savepoints - check your JPA provider's…
Nassim MOUALEK
  • 4,702
  • 4
  • 25
  • 44
7
votes
2 answers

In FirebirdSql, how to return exception message from procedure

I want to return the error message from a procedure when an exception happens. In SQL Server you would select the Error_Number() and Error_Message(). How would I do it in FirebirdSql SET TERM ^ ; CREATE PROCEDURE sprocname ( id int ) RETURNS …
edepperson
  • 1,035
  • 1
  • 14
  • 33
7
votes
1 answer

White spaces when updating varchar field using iif in firebird

I see strange result when executing this query update sd_invodt set line_type=iif(is_promo=1, 'campaign', 'item') The value in line_type field will be "item ". There are whitespaces in value. But when I execute this query update sd_invodt set…
Reynaldi
  • 1,125
  • 2
  • 19
  • 41
7
votes
2 answers

Compatibility of Firebird Client with Firebird Server

i have a question about Firebird Client and Server versions. I know that the Database-File have to match the Firebird Server due to ODS Changes. i.e. Firebird recommends to Backup/Restore the Database-File between Server-Version 2.5.1 and…
Andreas
  • 421
  • 4
  • 14
7
votes
1 answer

How to do a firebird SP, SELECT * FROM "TABLE"?

I'm migrating from SQL Server to Firebird. In SQL Server CREATE PROCEDURE Departments_GetAll AS SELECT * FROM Departments I try in Firebird CREATE PROCEDURE DEPARTMENTS_DELETEALL AS BEGIN SELECT * FROM "Departments"; END^ SET TERM ; ^ But…
zeqk
  • 85
  • 1
  • 5
1 2 3
…
99 100