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

EF with existing Firebird database model generation problem

I have a Firebird database with tables. I need to generate DbContext, models etc. So provider installed: Connection string is OK: Console.WriteLine("Starting"); FbConnection db = new…
Nevega
  • 39
  • 1
  • 9
1
vote
1 answer

Change the size of a varchar in the RDB$FIELDS table in Firebird

I am trying to change the varchar size of the CODE field of my FAIXA_VALORES table, however when trying to change it with the following code: update RDB$FIELDS set RDB$FIELD_LENGTH = 50, RDB$CHARACTER_LENGTH = 50 where RDB$FIELD_NAME =…
Gxbrielramires
  • 11
  • 3
1
vote
1 answer

I/O error during CreateFile (open) operation for file "3050/var/lib/firebird/data/corp". The system cannot find the path specified

I am getting an error "The system cannot find the path specified" trying to connect to Firebird 3.0 using SymmetricDS. Here is the error and my root node configuration (engine.name=corp-000). # The class name for the JDBC Driver…
Edward Chome
  • 37
  • 2
  • 6
1
vote
1 answer

How to join tables in two Firebird databases?

Currently I'm working on a simple library project using Embarcadero C++Builder 10.3 Community Edition, and Firebird and FlameRobin to create databases. So far, I need only use simple queries, that were connected to a single database. Therefore, I…
michmad93
  • 11
  • 1
1
vote
1 answer

Is the cursor variable updated when updating a row?

In the code below (stored procedure body), whether the value of the cursor field is automatically updated after UPDATE or not? If not, is the Close / Open command sufficient again or not? I didn't find any description that included this, it was just…
Himer Norbert
  • 41
  • 5
1
vote
2 answers

How to delete large data from Firebird SQL database

I have a very large database (at least for me) - above 1 000 000 records and I need to delete all records that are with a timestamp lower than something. Like for example: DELETE FROM table WHERE TS < 2020-01-01; The problem I'm facing is that…
Tony
  • 618
  • 12
  • 27
1
vote
2 answers

Variable number of parameters in a Firebird stored procedure

I have the following stored procedure: ALTER PROCEDURE SP_STOCK_ANALYSIS ( MAIN_GROUP CHAR(6) ) RETURNS ( STOCK_CODE CHAR(21), STOCK_GROUP CHAR(6), DESCRIPTION CHAR(31), EXPENSE NUMERIC(15, 4) ) AS BEGIN FOR SELECT …
gdekoker
  • 185
  • 8
1
vote
1 answer

Is it possible to UNION two EXECUTE BLOCK statements?

Is there a way to perform a union of 2 sets where both were output by 2 different execute block commands? The sets structure are the same but each one contains different parameters therefore I cannot easily merge both in one execute block…
Jonathan Livingston Seagull
  • 844
  • 10
  • 22
1
vote
1 answer

FBCommand Column Unknown?

I'm using FBCommand to insert data into a single table in ASP.NET and using the In my insert method, I create the following…
Moonpaw
  • 55
  • 8
1
vote
1 answer

Reading raw binary data from Firebird BLOB SUB_TYPE TEXT

At the first glance, my problem seems to be quite trivial. I have to read data from Firebird's database, but this database was created by someone else. Raw binary data (like pictures) is stored in BLOB SUB_TYPE TEXT instead of BLOB SUB_TYPE BINARY…
rgb
  • 1,750
  • 1
  • 20
  • 35
1
vote
2 answers

Firebird Interbase Connection - unset() and ibase_close()

I have a silly question. Is there a difference between unset() and ibase_close() in terms of ending connection to Firebird Database using ibase_connect()? I know that some people use unset() to PDO connections etc. Like: $connection =…
whocares4400
  • 106
  • 7
1
vote
2 answers

FirebirdSQL getting list of databases in C#?

I need to get the list of databases from a Firebird server in a computer. I want to select and backup whichever database I want. Microsoft SQL Server has that feature, I think you can see the databases connect a server. Is there such thing in…
Icarsel
  • 13
  • 6
1
vote
1 answer

I need to insert dynamically the field names and values old and new in a trigger, in firebird 2.5

I can insert table column names dynamically the problem is when I want to insert the new or old values in my log table I am getting a string 'old.Colname' or 'new.Colname' instead of old or new value. DECLARE C_USER VARCHAR(255); DECLARE VARIABLE…
Edward Chome
  • 37
  • 2
  • 6
1
vote
2 answers

Unable to read data from fixed size C array in Swift with out of bounds data

I am working with a library written in C, Firebird, in my Swift project. I have a fixed size C array, of size 1, in a struct typedef struct { ... ISC_SHORT sqln /* number of fields allocated */ ISC_SHORT sqld; /* actual number of…
ugocottin
  • 64
  • 8
1
vote
1 answer

Firebird column unknown on SELECT AS

I have a table of calls and their durations: +----+---------------+---------------+---------------+ | ID | CALLER_NUMBER | CALLEE_NUMBER | CALL_DURATION | +----+---------------+---------------+---------------+ | 0 | 1xxx0001020 | 1xxx3024414 | …
user7401478
  • 1,372
  • 1
  • 8
  • 25
1 2 3
…
99 100