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

3372 questions
1
vote
1 answer

Escaping quote in firebird isql result

I have simple bash scripts that query one Firebird database with isql and pipes the results to isql connected to another database. The first result set is of the form UPDATE ... or INSERT ... and the second isql executes those. Up to now the data…
Rick DeBay
  • 185
  • 2
  • 12
1
vote
1 answer

Can I use JBoss AS 5 or 6 with a Firebird or InterBase SQL server?

Today I tried to configure a JDBC resource in the JBoss AS 6 RC1, and encountered a field which requires a RAR name. If I have a database with a JDBC driver, do I also need a RAR file for the configuration in JBoss AS? In GlassFish v3, only the JDBC…
mjn
  • 35,561
  • 24
  • 160
  • 351
1
vote
2 answers

SQL Select Group By Min() - but select other

I want to select the ID of the Table Products with the lowest Price Grouped By Product. ID Product Price 1 123 10 2 123 11 3 234 20 4 234 21 Which by logic would look like this: SELECT ID, …
Michael Müller
  • 323
  • 3
  • 18
1
vote
3 answers

Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding)

When I try to connect to a Firebird database with dbeaver this error is shown: Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding). Please specify a connection character set (eg…
Yuliem Alavez
  • 53
  • 1
  • 5
1
vote
1 answer

Python script stops, no errors giving

I have an python script that needs to be running all the time. Sometimes it can run for a hole day, sometimes it only runs for like an hour. import RPi.GPIO as GPIO import fdb import re con =…
Ynias Reynders
  • 199
  • 11
1
vote
1 answer

Optimize SQL statement for this Query?

I have two tables T1 and T2. T1 have ID,F1,F2,F3,F4,F5,F6,F7,F8 T2 have ID,T1_ID,F1,F2,F3,F4,F5,F6,F7,F8,SUM Examples Data for T1 and T2 T1 ID,F1,F2,F3,F4,F5,F6,F7,F8 1, 1, 2, 3, 0, 0, 5, 0, 0 2, 0, 0, 0, 1, 0, 4, 5, 0 3, 4, 1, 3, 2, 0, 0,…
user2531567
  • 23
  • 3
1
vote
0 answers

Firebird local vs remote connection

I have a cloud-service based on firebird databases. Every customer has his own database file. So many connection-definitions are loaded into my service at startup. This works all well. Currently the load for the server is ok so the database files…
Andreas
  • 306
  • 3
  • 14
1
vote
0 answers

PHP Warning: ibase_query(): supplied resource is not a valid Firebird/InterBase link resource

When I submit the form of register new user or new client, this message error appears. I'm using PHP 7.1.5 with IIS Server in a Windows 10 OS. The same code was working correctly and stop work from nothing. Somebody can help me? Here is the…
Jonismar Morais
  • 11
  • 1
1
vote
3 answers

operations with time firebird

To resolve the issue. There are two meanings Time: 12:20 and 23:55. How can add the values that-be at the outlet was 36:15. Or how to keep these values in dB (Time) Time except that, were it possible addition?
mr. Flagman
  • 31
  • 4
1
vote
1 answer

Identifying the current table and record values in a Firebird UDF

I'm researching how to create a UDF to replicate a complete record of a Firebird table using triggers. I want to create a revision/history about some tables, replicating the data to a mongodb database using a UDF to connect to the mongodb and…
Beto Neto
  • 3,267
  • 3
  • 38
  • 70
1
vote
2 answers

Best SQL statement for this table?

I have table with 9 fields ID, F1..F8. An example of some data: id f1 f2 f3 f4 f5 f6 f7 f8 1 1 2 3 0 0 0 0 0 2 0 1 0 3 2 0 0 0 3 4 0 5 2 1 0 0 0 4 0 0 0 0 0 0 1 4 5 2 0 0 0 0 1 3 0 6 2 0 0 0 0 1…
user2531567
  • 23
  • 3
1
vote
1 answer

When to manually re-calculate indices statistics

I have an application which stores continuous data. Rows are then selected based on two columns (timestamp and integer). To keep the performance as good as possible, I have to recalculate statistics for indices, but I have two problems with…
Artholl
  • 1,231
  • 1
  • 17
  • 35
1
vote
1 answer

Firebird 1.5 Union

I'm trying to get a report to show different results in each line select count(case when call_type='I' and cl.client_ID not like 391 and c.call_start >= '2017/04/01' and c.call_start <= '2017/04/30'then 1 else null end) as Incoming_Main_April,…
Leo Fazzi
  • 91
  • 6
1
vote
1 answer

Firebird SQL statement with UNION gives data type unknown even with cast

I have the following query where in one of the union queries, a field has to be 0, and in the other part it gives an average from a subquery. I have to use a SELECT subquery. I can not use JOINS as it will yield doubled records in the result set …
Erik Van Gorp
  • 11
  • 6
1
vote
1 answer

How to prompt a message to a C# Program from a firebird database Insert Procedure

I have here an insert procedure in firebird, what it does is to verify if the data I am trying to save is existing in the table. If the data I am trying to save exist in the table, then the data will not be saved. If this is the case, How will I…
Don Juan
  • 145
  • 1
  • 10
1 2 3
…
99
100