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

two counts based on field value

I have a table table1 that has a field1 has values from 1 to 5 I need to get the count of records when field1 = 1 and the count of remaining records when field1 <> 1. so I could do it like this: select count(*) from table1 group by field1 =…
zac
  • 4,495
  • 15
  • 62
  • 127
0
votes
0 answers

Firebird 3, ADO.NET data provider 5.0.5, memory gradually growing

After changing the firebird 2.1 to 3.0 (SuperServer) is gradually rise much memory up to a maximum of hardware (20GB) for about one month. Firebird server has 6 database with a total size of about 30 gigabytes. Client applications are .NET WinForm…
Majkl
  • 765
  • 1
  • 9
  • 25
0
votes
2 answers

WCF REST service and client notifications

Here is my situation: I have a Firebird database, a WCF REST service (.NET 4.5) and a Windows Mobile 6 client. What I need is: on Firebirds post event, WCF REST should notify the client. I know that WCF has duplex communication when used as SOAP…
Aleksandar
  • 276
  • 1
  • 10
0
votes
1 answer

Job for firebird3.0.service failed because a configured resource limit was exceeded

Error when install and after when try to start Firebird 3.0 Service. Job for firebird3.0.service failed because a configured resource limit was exceeded. See "systemctl status firebird3.0.service" and "journalctl -xe" for details. invoke-rc.d:…
Wellington1993
  • 340
  • 1
  • 3
  • 17
0
votes
1 answer

Cannot connect to Firebird 3.0 using ODBC

I have installed Firebird 3.0 (Firebird-3.0.0.32483_2_x64) under Windows 7 (64 bit). I have created a Firebird database using ISQL and want to copy data to it from a Microsoft Access database. I have installed the Firebird ODBC driver…
Mike B
  • 1
  • 3
0
votes
1 answer

Firebird and Hibernate - How do you specify a DB role?

I'm working in a new project to convert our Delphi + Firebird system to Java 8 / JavaFX / JPA (Hibernate) and Firebird. We are using the latest version of Jaybird and connecting to Firebird 1.5, Firebird 3.0 and InterBase XE3 databases. I have not…
David Culbertson
  • 11
  • 3
0
votes
1 answer

How to update records based on values from another table?

I use Firebird 3.0 and I have 3 tables: Table1: tbl1_id (PK), f2_id (FK), tbl1_f1 tbl1_f2 is a foreign key to table2 Table2: f2_id (PK), f3_id (FK) f3_id is a foreign key to table3 Table3: f3_id (PK), tbl3_code Now I need to set Table1.tbl1_f1…
zac
  • 4,495
  • 15
  • 62
  • 127
0
votes
0 answers

undefined symbol: ib_util_malloc when trying to call a UDF

I created a very simple UDF, compiles fine but when I try to use it, it gives the following error: root@chii:/data/database/bot# /opt/firebird/bin/isql chii.fdb Database: chii.fdb, User: SYSDBA SQL> select YKUDF_PERLWRAPPER('/bin/ls' , '-al') from…
Sophia
  • 192
  • 12
0
votes
1 answer

Entity Framework migration script not working with firebirdsql

I'm using EF Migrations with a Firebirdsql Database and it works fine just fine while I update databases using the PackageManagerConsole in VS. If I use Update-Database -Script and then try to run the script I get an error. After a bit of testing I…
MaLKaV_eS
  • 1,325
  • 3
  • 23
  • 39
0
votes
0 answers

How to use Oracle code in Firebird

Oracle's alter session set nls_date_format = 'DD-Mon-YYYY', how do i use that in firebird? I tried casting but it does not work and extract and I can't get it work.
Anna
  • 1
  • 1
0
votes
1 answer

Firebird ADO.NET provider 5.0.5.0 to Firebird 3.0 can not connect except sysdba

I am trying connect to firebird 3.0 throught latest version of ADO.NET provider 5.0.5.0 from my simple test .net application. When i used sysdba user connection is made OK, but if i used other user then connection failed with classic FBException :…
Majkl
  • 765
  • 1
  • 9
  • 25
-1
votes
1 answer

How to return the first row after group by?

My table looks like the following: ID ITEMNO LOCATIONNO LOTNO INCOME OUTGO 1 AAA A-01 001 1 0 2 AAA A-02 002 1 0 3 AAA A-01 001 0 1 When a user sells an item, I want to show the oldest income LOTNO item (FIFO) to the user (lookup)…
Henry Olive
  • 7
  • 3
-1
votes
1 answer

Case when doesn't accept BEGIN

Case doesn't accept Begin I need to update 2 separate fields in one case, something like below UPDATE PYR SET MSR = Case When MSR = :WRKH then Begin MSR = NULL WRKDAY = WRKDAY -1 end; …
Henry Olive
  • 7
  • 3
-1
votes
1 answer

Query and total for each week

user, timeon, timeoff, hours Monday - 1510, 2021-10-25 05:00:00, 2021-10-25 09:00:00 - 1510, 2021-10-25 14:00:00, 2021-10-25 17:00:00 - The total should be 4 + 3 = 7 Tuesday - 1510, 2021-10-25 05:00:00, 2021-10-25 09:00:00 - 1510, 2021-10-25…
L_GIB
  • 125
  • 7
-2
votes
1 answer

Firebird database BLOB type with 20,000 bytes, which SQL Server data type to store blob?

Migrating data from a Firebird database to SQL Server. There is a BLOB Binary field which has values around 20,000 bytes which was measured using OCTET_LENGTH function. Which SQL Server data type will house more than 8000 bytes?
Dan
  • 2,209
  • 3
  • 23
  • 44
1 2 3
…
14
15