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
9
votes
6 answers

How to split comma separated string inside stored procedure?

How to split comma separated string into strings inside store procedure and insert them into a table field? Using Firebird 2.5
Yordan Yanakiev
  • 2,546
  • 3
  • 39
  • 88
9
votes
5 answers

Spring Data JDBC Firebird dialect not recognized

I'm trying to connect to Firebird database using Spring Data JDBC and Spring Boot. I've created a simple app using Spring Tools. Spring Data JDBC doesn't recognize the dialect. I believe the problem is that the DialectResolver doesn't support…
ndwd
  • 93
  • 1
  • 1
  • 3
9
votes
2 answers

Executing a script using ISQL

I'm creating a simple isql script but it's not working and I need some help to find out whats wrong with it. I need to connect to a database and execute a SQL file. This is my script called script.sql: CONNECT…
user729661
  • 91
  • 1
  • 1
  • 2
9
votes
2 answers

Firebird's SQL's Substring function not working

I created a view on a machine using the substring function from Firebird, and it worked. When I copied the database to a different machine, the view was broken. This is the way I used it: SELECT SUBSTRING(field FROM 5 FOR 15) FROM table; And this…
Mario Marinato
  • 4,561
  • 3
  • 29
  • 49
9
votes
2 answers

How to convert character set from ISO8859_1 to UTF8 in Firebird?

I have a database in Firebird 2.5 filled with data. I need to change the character set from UTF-8 to ISO8859_1, I tried: alter database default character set ISO8859_1 collation ES_ES But it doesn't work. How can I convert the character set?
Quiron
  • 340
  • 2
  • 12
9
votes
1 answer

Equivalent function to STUFF in SQL (GROUP_CONCAT in MySSQL / LISTAGG in Oracle)

Does anyone know if Firebird 2.5 has a function similar to the "STUFF" function in SQL? I have a table which contains parent user records, and another table which contains child user records related to the parent. I'd like to be able to pull a…
Phil
  • 4,029
  • 9
  • 62
  • 107
9
votes
2 answers

Update a table with join?

I am trying to update table A with data from table B. I thought I can do something like this update A set A.DISCOUNT = 3 from INVOICE_ITEMS A join ITEM_PRICE_QUNTITY B on A.ITEM_PRICE_NO = B.ID where A.INVOICE_ID = 33 but getting error SQL…
Azad
  • 5,144
  • 4
  • 28
  • 56
9
votes
2 answers

Is it possible to extend Firebird table name length?

I'm a Firebird newbie here. I'm trying to use Firebird Embedded from an ASP.Net application. Everything connects fine but I'm running into problems with the length of column names. I'm trying to create a table named…
wwahammy
  • 467
  • 1
  • 5
  • 14
9
votes
2 answers

Define variable and run a query using EXECUTE BLOCK

I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do: SELECT * FROM customers WHERE customerid = 1234; I want to define 1234 as a variable, say customerID,…
Valentin Despa
  • 40,712
  • 18
  • 80
  • 106
9
votes
3 answers

How to use GROUP BY in Firebird?

The structure of T_TABLE2 is ID INT TBL1_ID INT TESTER VARCHAR LOT_ID VARCHAR GRP VARCHAR SITE_NUM INT TEST_NUM VARCHAR TEST_DESC VARCHAR MEASUREMENT DOUBLE PRECISION UNIT VARCHAR LL DOUBLE PRECISION UL DOUBLE PRECISION STATUS VARCHAR and I use SQL…
aiipee
  • 252
  • 3
  • 9
  • 18
9
votes
0 answers

Any way to use a Firebird embedded database on a native (NDK) Android app?

I'm looking at migrating a Windows program to Android. It uses a local Firebird database with fbembed.dll. I've looked around the Internet and run a few searches, but the only Firebird clients I've found for Android are JDBC drivers. But this…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
9
votes
1 answer

Entity Framework Code First - Cast smallint and integer to int32

Im working on a small service tool for a database. My problem is that due the last update, some smallint-colums had to be be changed into integer. public class TEST { public int ID { get; set; } //public Int16 ID { get; set; } public…
Dust258
  • 485
  • 1
  • 3
  • 18
9
votes
5 answers

Firebird x Windows 7 x gds32.dll error

I have a fdb file (firebird) from a new client (he doesn't know the version). I have tried to use some GUI to access the database, but with no luck. All of them tell that its missing gds32.dll, but I have this one. I have copied this dll to the GUI…
Olivertech
  • 567
  • 2
  • 4
  • 24
9
votes
5 answers

experiences with firebird server over the internet with multiple clients?

Has somebody real experience with firebird databases over the internet? I have a typical windows accounting/ERP software (done with delphi) that works with the firebird database server pretty well.. Now my users (300 aprox. now, but should…
pragmatic_programmer
  • 3,566
  • 3
  • 29
  • 36
8
votes
1 answer

Cast as Int only when character is a number on Firebird 2.5

I have a query that I use on a MySQL database that orders the result, casting a char database field to integer when possible (when the char string is numeric), so for example the ORDER BY clause that I use on MySQL is: ORDER BY CASE WHEN…
aleroot
  • 71,077
  • 30
  • 176
  • 213
1 2 3
…
99 100