Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

For questions specific to Firebird 3.0. It is advisable to also tag with firebird.

Firebird 3.0 is a previous release of the Firebird database server. The latest release is .

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

211 questions
4
votes
1 answer

How to correctly migrate from Firebird 2.5.1 to Firebird 3.0?

I'am trying to migrate Firebird 2.5.1 to Firebird 3.0 What is done: Back up on Firebird 2.5.1 Restore on Firebird 3 The problem is that not all tables were migrated; procedures, triggers and views are not recovered. Why? Is anywhere manual how to…
May12
  • 2,420
  • 12
  • 63
  • 99
4
votes
3 answers

Flamerobin connection failed with Firebird 3.0 in Ubuntu 16.04 LTS - Error: connection rejected by remote interface

I just installed Firebird 3.0 in Ubuntu 16.04 LTS. I can connect to the server with Flamerobin from a Windows computer. I also installed Flamerobin in the server to be able to manage the databases locally, but after to register the server and…
AngelAvila
  • 427
  • 5
  • 15
3
votes
1 answer

Overlapping date ranges for all workers

I'm trying to figure out how to calculate date ranges (islands) where all workers worked all together. In other words, if one of the workers is not at some date, then this date should be excluded from the result. Below sample data: insert into…
Livius
  • 958
  • 1
  • 6
  • 19
3
votes
1 answer

Returning a table in firebird 3.0 with stored function or stored procedure

I'm trying to write a stored procedure/function that returns me a table with one or multiple rows of data. The returned data depends on a variable shown in the following sql statement: SELECT * FROM table_name AS SD WHERE EXISTS (SELECT DISTINCT…
Zazimba
  • 33
  • 4
3
votes
1 answer

Firebird database UDF for encrypt/decrypt not freeing memory

I'm testing a UDF external function in Firebird 3 database, I made a C++ DLL which performs a simple XOR to a given string using a given key. This is the code: #include #include #include #include #include…
Pablo Sanchez
  • 133
  • 2
  • 8
3
votes
2 answers

Query optimization with in (select ...) clause

I'm using Firebird WI-V3.0.4.33054 on Windows. I'm having trouble optimizing this query, that uses an in clause with a select: update CADPC p set p.STA = 'L' where p.COD in (select distinct CODPC from CADPCI_Rec where IDNfr = 27) and not exists…
GabrielF
  • 2,071
  • 1
  • 17
  • 29
3
votes
1 answer

Firebird 3.0 Encryption with AES128 plugin - Unable to connect

I'm using Firebird 3 with encryption via the AES128 plugin found here. https://www.ibphoenix.com/products/software/encryptionplugin I have successfully encrypted the database, and I am able to connect and query it using isql however I am not able…
Phil
  • 4,029
  • 9
  • 62
  • 107
3
votes
1 answer

Table drops not actually done by Firebird until application closed

I have a .net test application which creates table, uses them, then drops them, many times. When I run this application against a Firebird 3.0.2 database with Firebird ADO.Net Data Provider 5.9.1, it fails at soon as it has to create a table with…
Frédéric
  • 9,364
  • 3
  • 62
  • 112
3
votes
3 answers

Counting entries depending on foreign key

I have 2 tables, let's call them T_FATHER and T_CHILD, where each father can have multiple childs, like so: T_FATHER -------------------------- ID - BIGINT, from Generator T_CHILD ------------------------------- ID - BIGINT, from…
Sebastian Proske
  • 8,255
  • 2
  • 28
  • 37
3
votes
1 answer

How to run firebird as an application?

I have downloaded ZIP file and unpacked it. Now, it is said, that FB can run as an application. How to run it this way? Running firebird.exe does nothing. I don't want to install it as a service.
Dims
  • 47,675
  • 117
  • 331
  • 600
3
votes
1 answer

Unable to connect Firebird 3.0 embedded version

I have tried to connect to Firebird database file using IBExpert and Flamerobin always got this error "Unable to complete network request to localhost" Is there any changes in Firebird 3.0 with embedded version, because I can connect to version…
PHP4PRO
  • 121
  • 2
  • 5
3
votes
1 answer

How to use a transaction parameter block with the Firebird 3 OO Api

I've been playing with the new Firebird.pas interface included with Firebird 3. I'm having an issue when I try to use a custom transaction parameter block. I seem to always get the error "invalid format for transaction parameter block" if I add…
MarkF
  • 1,616
  • 1
  • 17
  • 27
3
votes
1 answer

Does Firebird ADO.NET 4.10.0.0 Data provider work with Firebird 3.0?

I'm currently trying to get my ASP.net 4.5 project connecting to the recently release Firebird 3.0. I'm using Visual Studio 2015 Community edition, Firebird 3 (64 bit), and used NuGet to get the ADO.NET 4.10.0.0. However, when I try to connect, I…
CSharpNewb
  • 181
  • 5
  • 15
3
votes
2 answers

Firebird Create function TRANSLATE as in Oracle

I try to create a function with the same functionality as the TRANSLATE function in Oracle, I have created function in Oracle and it works good but I have a problem when I try rewrite this code to Firebird. I get an error that 'expression evaluation…
Tom
  • 301
  • 1
  • 3
  • 9
2
votes
1 answer

What is the purpose of the '.' operator in a firebird database query?

When I am executing the SQL query below against A Firebird database (version 3.0.9) running on a Windows 10 64 bit PC. SELECT * FROM AliasName WHERE AliasId=3. or 1=1-- I expected the query to fail with an error, but strangely Firebird executes the…
mjk6035
  • 121
  • 1
  • 10
1
2
3
…
14 15