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
0 answers

Node ODBC problem with non english characters

I'm using node/odbc for connection to a Firebird database, but I cannot see the characters with accent and other Spanish characters. I tried to set the charset in the connection string const odbc = require('odbc'); odbc.connect('DSN=mydnsname;…
wakeup
  • 67
  • 7
1
vote
0 answers

Firebird Stored Procedure for dynamically selection

We are working with firebird 2.5. I have the following structure. TABLE ARTICLES(ARTNR INTEGER NOT NULL PRIMARY KEY , S1 INTEGER , S2 INTEGER ..... S10 INTEGER) TABLE S1..S10(ID INTEGER NOT NULL PRIMARY KEY , DESCRIERE VARCHAR(40)) There are…
Popa Ovidiu-Razvan
  • 475
  • 1
  • 5
  • 22
1
vote
3 answers

ID-ing Deadlocks in a Thread using Firebird

Developer looking for best method to identify a deadlock on a specific transaction inside a specific thread. We are getting deadlock errors but these are very general in FB 2.0 Deadlocks happening and they are leading to breakdowns in the DB…
mysharrona
1
vote
1 answer

How to skip/continue delete statement when the table does not exist?

I want to write execute block that I can use for multiple databases with similar structure, some don't have 1 or more tables. I use something like this execute block as begin delete from table1; delete from table2; delete from table3; delete…
Flash
  • 11
  • 2
1
vote
1 answer

Result Set from a TFDScript?

I found some code which works in FlameRobin to return the number of records for all tables in the database but am only able to run it in a TFDScript which works fine but no result set is accessible. I tried various ways in TFDQuery and TFDCommand…
Richard Shuck
  • 113
  • 1
  • 10
1
vote
1 answer

TIBScript and local variables

I am working with Delphi 7 and Firebird 2.0. In my application I am using TIBScript components. The problem arises when I use local variables in the script. Firebird requires the names of local variables to be preceded by a colon in some cases.…
Rick77
  • 241
  • 3
  • 21
1
vote
2 answers

Firebird determine if a string is all numbers

I have a VARCHAR field in a Firebird 2.0 table that can contain alphanumeric characters. I need to sort data on this field, sorting all values that contain only numbers as numbers, and sort all other values as 0. For example, if I have four values,…
Rytis
  • 1,447
  • 1
  • 19
  • 38
1
vote
1 answer

How to restore a Firebird database in a Python script using FDB?

Firebird 3.0.4 is installed and Python v3.7.7 on a Windows10 64 bits system. I can restore a database with the following command: gbak.exe -r -USER user -PASSWORD password database.fdk database.fdb I would like to do the same using fdb (Firebird…
hganger
  • 147
  • 2
  • 12
1
vote
1 answer

Create a table with a foreign key referencing to a temporary table generated by a query

I need to create a table having a field, which is a foreign key referencing to another query rather than existing table. E.g. the following statement is correct: CREATE TABLE T1 (ID1 varchar(255) references Types) but this one throws a syntax…
RedSoft
  • 148
  • 8
1
vote
1 answer

Get an error when connecting to Firebird database

Springboot: pom.xml org.firebirdsql.jdbc jaybird 4.0.0.java8 application.properties spring.datasource.url=jdbc:firebirdsql://SERVER:3050/D:\company\DbPro\Data\file.fdb spring.datasource.driverClassName=org.firebirdsql.jdbc.FBDriver I get an…
Andrey Konus
  • 11
  • 3
1
vote
2 answers

Python Database Cursor Exception Timing

I'm creating a class that will manage a connection to a Firebird database. The Firebird Service will be installed to facilitate multiple connections to the database. Unfortunately, the environments where my software will deploy can be volatile,…
g.d.d.c
  • 46,865
  • 9
  • 101
  • 111
1
vote
1 answer

Assign multiple params from single (singleton) select in Firebird?

In a Firebird execute block I want to execute a singleton select and assign multiple columns to a set of parameters/variables. I know a single value can be assigned with :param = (select ...) and that I can also loop through a result set and assign…
Kjell Rilbe
  • 1,331
  • 14
  • 39
1
vote
1 answer

Create trigger to UPPER() Firebird data

I have a query to UPDATE or INSERT data in my Firebird, but this values come from what user type, so I want to create a pattern, all data as Upper. It's possible do it in Firebird 2.5? My #1 test "UPDATE OR INSERT INTO ENTIDADE_001 (CODCLI,NAME)…
migow
  • 25
  • 3
1
vote
1 answer

Unable to select from table starting with "@" in Python fdb

I'm using FDB module to fetch data from Firebird database using Python. I'm trying to fetch data from table named @TABLE_NAME, it was not my idea to include "@" in the table name, and it makes it impossible to execute statements on it. When I try to…
Filip Napierala
  • 13
  • 3
1
vote
2 answers

SQL 'CASE' Clause - Column Name Names Itself CASE

I'm trying to SELECT multiple columns from my table 'EXAMPLE_1' and call a CASE-expression on one of them. When executing it shows every column as it's supposed to, but the one I called the CASE-expression on has the name 'CASE'. How do I fix this?…
june4
  • 30
  • 4
1 2 3
…
99 100