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
1
vote
1 answer

Is SQL merge good replacement for single-table select-check-update statements?

I have table adv_days(adv_date date not null primary key, edit_state integer) and I want to do series of commands: check wether '27.11.2019' exists in table, if exists then update edit_state to 1, if does not exist, then insert date '27.11.2019'…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
1 answer

Prevent firebird .GDB database to be opened

I have a firebird database in format .GDB. If I setup a interbase server and I open the .GDB with (for ex. IB Expert) with the default password I can open the Database. So I'd like to prevent the database to be opened by other softwares how could I…
okami
  • 11
  • 2
1
vote
2 answers

Could not find driver ( PHP and Firebird )

I have a web-based PHP script named portail, so I want to make it functional on Ubuntu. I installed Xampp 5.6 , Firebird 2.5 under Ubuntu, then I uncommented the library: "extension=php_pdo_firebird.dll" and I made the specific configuration for…
SMO
  • 33
  • 3
1
vote
3 answers

Count double occurrences in order list

I have a list of orders, I need to find which ones occur with code 47 more than once with different users. For example: ORDER_ID CODE USER 111 47 1 111 47 2 222 47 1 333 47 1 333 47 2 444 47 1 …
Jonathan Livingston Seagull
  • 844
  • 10
  • 22
1
vote
0 answers

What factors do influence the Catalyst app restart mechanism? (Firebird connection)

I have a problem like in this question I have a Perl Catalyst application which is launched normally using the -r parameter. I have noticed 2 types of behaviour: 1) the application restarts normally on every "dummy change" of the code (by…
Lex
  • 319
  • 1
  • 4
1
vote
1 answer

Resolving a singleton error in a stored procedure

I have the following stored procedure in Firebird SQL: ALTER PROCEDURE SP_REPORT_USD ( PER SMALLINT ) RETURNS ( ACCOUNT_NUMBER CHAR(21), AMOUNT NUMERIC(15, 4) ) AS BEGIN SELECT L.ACCOUNT_NUMBER,…
gdekoker
  • 185
  • 8
1
vote
1 answer

Assistance with Firebird SQL stored procedure

I have a very simple stored procedure: ALTER PROCEDURE SP_BALANCE_USD ( PER SMALLINT ) RETURNS ( ACCOUNT_NUMBER CHAR(21), AMOUNT NUMERIC(15, 4) ) AS BEGIN SELECT L.ACCOUNT_NUMBER, SUM(-(CURRROUND(L.DEBIT,2) -…
gdekoker
  • 185
  • 8
1
vote
1 answer

How to decode this hexadecimal blob?

I'm trying to decode this Firebird blob to extract decimal numbers from it (not sure exactly what format they'll be in). Some context is the blob is storing vibration spectrum data charting amplitude against frequency. I'm pretty sure that the blob…
Rory LM
  • 160
  • 2
  • 15
1
vote
1 answer

Jaybird SocketInputStream.socketread0 thread blocking

I am using JDBC connection to firebird. org.firebirdsql.jdbc jaybird-jdk18 3.0.5 When I am reading data with: resultSet.next(); //resultSet is instance of FBResultSet sometimes thread…
Altair
  • 325
  • 3
  • 16
1
vote
1 answer

Blob storage in firebird increases database file size

I have to store file data in a blob field using Firebird. Every time I execute the query, the database file size increases, even if it is executed with the same parameters. Is it possible to avoid this problem? update or insert into…
malom
  • 223
  • 2
  • 11
1
vote
0 answers

"too many open handles to database" and ibase_prepare

On my new brand AWS server I have a big problem with PHP and Firebird DB. Current configuration: Debian 10 (buster) PHP 7.3.11-1~deb10u1 (cli) (built: Oct 26 2019 14:14:18) ( NTS ) LI-V3.0.5.3310 Firebird 3.0 Super This is not real code from my…
Leonardo Cosmai
  • 11
  • 2
1
vote
0 answers

Connection to firebird from powershell script

How can I connect to firebird database from powershell script (.ps1)? Can someone provide me the code? I've tried with an SQL server and got no problem with that but I need to make a connection to firebird. Your comments are heartily…
Rajnikant
  • 11
  • 3
1
vote
1 answer

Firebird build CSV string of 1 field from multiple rows in SQL

In Firebird 2.5 or 3.0, and Delphi 10.2: In a master-detail configuration, where there's always at least 1 and and not more than 4 or 5 detail rows per master, I need to get a single row that has certain fields from the master row and a field that…
SteveS
  • 335
  • 1
  • 13
1
vote
1 answer

How to handle precision problems of floating point numbers?

I am using Firebird 3.0.4 (both in Windows and Linux) and I have the following procedure that clearly demonstrates my problem with floating point numbers, and that also demonstrates a possible workaround: create or alter procedure test_float returns…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
0 answers

How do I prevent FireDAC from unpreparing the statement when closing the query?

I want to repeatedly open/close a TFDQuery without having the overhead of preparing each time but calling TFDQuery.Close automatically unprepares the query. I have tried XE6 and Studio 10 with FireBird 3.0. I initially thought it was my…
Richard Shuck
  • 113
  • 1
  • 10
1 2 3
…
99
100