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
1
vote
1 answer

FirebirdSQL union duplicate records

Using FirebirdSQL 3.0.2. I am trying to pull out a report with fixed rows in it. Meaning, I would like to have certain number of rows each time even. If certain row does not exists in result set, I would like to display that missing row having…
Ertan Küçükoglu
  • 31
  • 11
1
vote
3 answers

Backup/Restore of Firebird SQL Server 3.0.2 is slow on Windows Server 2016

I have installed Firebird 3.0.2 SQL database on my Windows Server 2016. No other software has been installed yet. I'm using Superserver mode and an SSD drive. When I just copy my database file of size 6 GB, it is done in 20-30 seconds (same…
mojmir.novak
  • 2,920
  • 3
  • 24
  • 32
1
vote
0 answers

Two instances of a stored procedure causes "Lock conflict on no wait transaction" on alter procedure

I am experiencing problems with Firebird 3 when I display a stored procedure in Firebird Maestro, and after that I open another Firebird Maestro instance opening the same stored procedure, when I try to change and "recompile" the stored procedure,…
Marcoscdoni
  • 955
  • 2
  • 11
  • 31
1
vote
1 answer

How to get date format as "yyyy mm/dd"?

I am trying to output a time stamp field from view in this format yyyy mm/dd so I tried like this: extract(year from mytable.order_date)||' '||extract(month from mytable.order_date)||'/'||extract(day from mytable.order_date), however there is no…
zac
  • 4,495
  • 15
  • 62
  • 127
1
vote
1 answer

How to perform update on binary blob in Firebird stored procedure?

The challenge is in stored procedures to assemble a binary value to blob and then save the table. The problem is that the stored procedure works with the blob as text, e.g., if I want to insert into blob byte 4, than byte 52 is inserted (for byte…
Majkl
  • 765
  • 1
  • 9
  • 25
1
vote
3 answers

Count in Firebird 3.0 bigint vs Firebird 2.5 integer

On my system, after the migration from Firebird 2.5 to 3.0, many reports and other functions began to give problems stating that what was expected was Integer and the current one is LargeInt. I took a look and saw that some searches with the count…
sounobre
  • 420
  • 1
  • 6
  • 16
1
vote
2 answers

sql stored function gives an error

I am trying to create a stored function to take one parameter called budget. The function should return the string 'LOW' for a budget less than or equal to 500000, 'MID' for a budget less than or equal to 850000, 'HIGH' for a budget less than or…
Austin
  • 93
  • 1
  • 8
1
vote
1 answer

Firebird strip procedures, trggers views and udf

I am preparing a new version of my software, making the transition from Firebird 1.5 to 3. My installation program backs up the Firebird 1.5 database and restores it through the Firebird 3 server or embedded server depending on the installation type…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
1
vote
0 answers

Firebird 3 do Firebird 2.5 Free-Adhoc UDFs work?

I am currently running an application on Firebird 1.54 and working on an Upgrade to 2.56. As Firebird 3 is released, I would like to directly go to this version but I need the great Free-AdHoc-UDFs as users also have custom statements in their…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
1
vote
0 answers

Firebird SQL SUBSTRING : "expression evaluation not supported

I'm trying to run the following query on a database to replace the leading characters of certain rows. UPDATE table SET path = :newpath || SUBSTRING(path FROM :pathlen) WHERE path STARTING WITH :oldpath So for parameter :newpath = foo, :oldpath…
Roddy
  • 66,617
  • 42
  • 165
  • 277
1
vote
1 answer

Token unknown in Firebird

This query is throwing an error on firebird, how to resolve that error? SELECT EMPNO,SAL FROM EMP E where EMPNO = (SELECT MAX(DEPTNO) FROM DEPT D WHERE E.ENAME NOT like (SELECT TOP 1 ENAME …
kvk30
  • 1,133
  • 1
  • 13
  • 33
1
vote
1 answer

No privilege for this operation

Extracted code from documentation, create table sales_catalog( item_id varchar(10) not null primary key, item_name_desc varchar(50) not null, item_desc varchar(50)); Error after using SYSDBA as the user in Firebird SQL3. Statement failed,…
kvk30
  • 1,133
  • 1
  • 13
  • 33
1
vote
0 answers

Firebird 3.0 on Ubuntu Xenial fails to start

I'm trying to install Firebird 3.0 on Ubuntu xenial. I'm using this command to check the server status: Job for firebird3.0.service failed because a configured resource limit was exceeded The answers is this: ● firebird3.0.service - Firebird…
Britto
  • 475
  • 1
  • 8
  • 24
1
vote
0 answers

Jaybird driver difficulty, cannot connect to firebird server

I've been trying to connect to a localhost firebird server via Netbeans IDE. When I test the connection I get a connection rejected by remote interface error. I tried to connect using the password masterkey and my personal password but to no avail.…
Maurice
  • 6,698
  • 9
  • 47
  • 104
0
votes
0 answers

FB3 Common Table Expression

I'm trying to get a vendor's Delivery Performance like below result TotalDelivery 51 OnTime 50 Delayed 1 Percentage 98 With below SQL I'm getting PERCENTAGE value always 0 What am doing wrong ? Thank You Orders Table : ID, CUSTNO, TDATE,…
Henry Olive
  • 7
  • 3
1 2 3
…
14 15