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

How to select column name in Firebird trigger after insert

I am using the Firebird trigger. I want to fetch party_name on the base of party_id after insert trigger. And insert party_name into the logs table. Here is my code. SET TERM ^ ; CREATE TRIGGER cash_after_insert CASH_FLOW AFTER INSERT POSITION 0…
Zon Ch
  • 21
  • 3
1
vote
1 answer

Performing SQL select distinct except BLOB field

I need to select some DISTINCT fields on a table, but I need to exclude blobs from the distinct, since distinct does not consider BLOB fields. I tried looking for something here, but this is what I found and it doesn't work for me, Invalid…
Denis Ndoja
  • 45
  • 7
1
vote
2 answers

Results from firebird DB columns are nameless just numbers

I'm using the following code to query my Firebird database, but the results do not include the column names, just numbers. It's my first time working with Firebird, I only worked with MySQL. Is there a way to get column names instead of…
BRABO
  • 100
  • 7
1
vote
1 answer

How do I connect from Azure Data Factory to a Firebird/InterBase (Syntess) database?

In ADF, I have created a pipeline. The source is an ODBC table or query. The next step is to create a Linked Service. The Integration Runtime has been created and selected as you can see below. Now comes the question: What connection string am I…
MeanGreen
  • 3,098
  • 5
  • 37
  • 63
1
vote
1 answer

Why fires the AfterScroll event of a nested (detail) dataset more than once when its master dataset scrolled to another record? How to deal with it?

I have a Delphi program with 3 successive nested (master-details) FireDAC datasets namely: SuperMaster, Master and Details dataset. In the AfterScroll event of the Details dataset only, new records are inserted into the database. My program logic…
HasDev
  • 65
  • 6
1
vote
1 answer

How to determine the character set of a Firebird database

I've read the following thread and I was able to make a conversion script (based on C#) that converts all my charset=NONE databases to charset=UTF8 and most of it works great (I still have a few special cases where characters are converted to weird…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
1
vote
1 answer

Bulk insert got weakly-referenced object no longer exists

I'm trying to use bulk_insert_mapping with SQL Alchemy and Firebird and I'm facing an issue. Note that a normal insert with session.add() works well. # This is a simple example that bulk insert filenames in history…
ebelair
  • 844
  • 11
  • 27
1
vote
0 answers

Why does my SQL code in IB Expert return some nulls

I have written this script: SELECT id_pass, max(dt) FROM parking_pass_move WHERE type_error is null and id_pass = 1784 GROUP BY id_pass HAVING max(dt) < '2021-07-02' And it returns: OK! But when I change my having row to: HAVING max(dt) <…
nyangoodye
  • 13
  • 3
1
vote
1 answer

Concat in Firebird - If one field is NULL all Content is NULL how to avoid?

How does one avoid creating a null field when doing a concat with a field that is null in Firebird. with data as ( select article_name || ' STK:' || cast(quantity as integer) || NOTES as quantity ,PREORDER_ID as PID from preorder_item ) SELECT…
Michael Pietzsch
  • 115
  • 1
  • 5
1
vote
1 answer

Unable to connect to Firebird server from ADO.net

I recently downloaded the new Firebird 4 server and installed it. It's running as a service on my Windows 10 box. I'm able to connect to it just fine with the FB Maestro IDE, but when I try to connect to it from some ADO.NET code, I get an error. …
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
1
vote
1 answer

Avoid unnecessary update in "update or insert" SQL?

Here is Firebird SQL description for update or insert: https://firebirdsql.org/refdocs/langrefupd25-update-or-insert.html And my example update or insert into books (id, name) values (555, 'Good book') matching (id) If book already exists with…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
3 answers

"SELECT column ... WHERE", knowing value of other column, can't use subquery

I'm working on this SELECT query: SELECT * FROM x JOIN y ON x.struktorg = y.ref WHERE y.rodzic = (SELECT ref FROM y WHERE y.symbol = 'the value i know') The goal is to not use subselect. I know the value of symbol column, but the table that I need…
malyGatsby
  • 11
  • 1
1
vote
1 answer

entity framework triggers don't fire

Can't get AFTER INSERT trigger to fire after SaveChanges() was done. Using T-SQL with ExecuteStoreCommand() doesn't help. All triggers are fired on the server, but not from the Entity Framework. What I am doing: I create a new row in parent…
desperate man
  • 905
  • 1
  • 17
  • 39
1
vote
2 answers

How to reverse the results of this query?

I'm using Firebird 2.1. There is a table name Folders, with these fields: FolderID ParentFolderID FolderName ParentFolderID is -1 if it's the root folder - otherwise it contains the parent folder's ID. The following recursive query will return the…
Steve
  • 2,510
  • 4
  • 34
  • 53
1
vote
1 answer

How to evaluate mathematical expressions in Firebird

I need a function for Firebird that evaluates a mathematical expression and gives me the result, I don't know if there is any, right now I'm using the foxpro eval () expression that allows me to do it, but I wanted to integrate all the calculations…
Jauma Tugores
  • 11
  • 2
1 2 3
…
99 100