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

cursor firebird move some rows tableA to tableB

I want to move specific lines (some fields) from a tableA to a tableB by deleting these rows from tableA. I use Delphi version Rio with FireDAC with Firebird RDMBS. I use a procedure to move and delete a single line I can not use this cursor to…
nabil doghmane
  • 1
0
votes
1 answer

Is a connection pool for Firebird embedded pointless?

I am creating an application server using firebird 3 embedded for the database. A connection pool usually speeds up things for short connections that make one transaction and disconnect. But does this also apply for embedded firebird where no…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
0
votes
1 answer

How to get total unused pages from firebird nbackup

I'm using firebird nbackup method to backup my database by using this code: nbackup -u systemdab -p masterskeys -B 0 DB01.FDB DB01.NBK After complete backup, the size is smaller than original size. It might be caused of removing unused pages (I'm…
JK Ainz
  • 35
  • 7
0
votes
0 answers

Getting percentage of a number with 5 decimal points

I am working on a inventory table with a field of Estimated Years Life of the item. I would like to get the % Month Depreciation of the Estimated Years Life field. SUPPLY_TABLE Field SUPPLY_ITEM SUPPLY_LIFEYEARS …
Don Juan
  • 155
  • 1
  • 10
0
votes
1 answer

firebird3.0.service failed because the control process exited with error code. How to start firebird?

I'm working with firebird3.0 database suddenly my database is stopped working and when i have checked server status by $ /etc/init.d/firebird3.0 status i see server is stopped ● firebird3.0.service - Firebird Database Server ( SuperServer ) …
Nitin Upadhyay
  • 113
  • 1
  • 15
0
votes
0 answers

How to retrieve Chinese language data from Firebird DB?

We have a Firebird DB with a large number of tables and data. Which has to support both English and Chinese languages. While retrieving the Chinese data from the DB, the data is automatically converted to some other format like this (è¿åŠ¨åž‹).…
Kathir Subramaniam
  • 1,195
  • 1
  • 13
  • 27
0
votes
2 answers

is there any way to pivot rows to columns dynamically without a specific no of columns in firebird

I need a way to display my data from rows to columns dynamically using sql. My row no. starts from 0 to N and I want to convert it to columns. I cannot use static column to match my requirement because the maximum no of rows changes every time…
Mandz
  • 195
  • 2
  • 17
0
votes
0 answers

Connect Firebird Database with Entity Framework model - Connection Failed

I want to connect the Firebird database with Entity Framework Model. Completed the successful installation and created the database. But, I am facing the issue 'Index was outside the bounds of the array' while connecting the database. Refer the…
Kathir Subramaniam
  • 1,195
  • 1
  • 13
  • 27
0
votes
0 answers

Session specific storage for UDFs in Firebird

For encryption purposes of some columns I wrote UDFs. I then realized that passing the keys through SQL is nonsense as the SYSDBA can trace SQL and look into session environment. And he exactly is the one, who should not access the data. Full…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
0
votes
2 answers

How to find tree nodes that don't have child nodes

Firebird Db stores chart accounts records in table: CREATE TABLE CHARTACC ( ACCNTNUM Char(8) NOT NULL, -- Account ID (Primary Key) ACCPARNT Char(8), -- Parent ID ACCCOUNT Integer, -- account count …
basti
  • 399
  • 2
  • 10
0
votes
1 answer

How to get number of rows from another table?

I have a table (table1) with a list of students from the highest to the lowest grade. I want to divide them in 3 groups. But how many students in each group? First I count how many student I have, then I look in table1 for the row where column…
Sahat
  • 29
  • 1
  • 7
0
votes
2 answers

How translate function from MySQL to Firebird?

how how can i transfer this function to firebird create function `candidat`(in_num decimal(10,2), in_group integer unsigned) returns integer unsigned deterministic language sql begin …
Sahat
  • 29
  • 1
  • 7
0
votes
1 answer

Why Delphi IBX TWideMemoField converts byte order in UTF8 string and how to avoid it?

I am using Delphi 2009 with IBX on Firebird 3 database (I have no choice to choose other technologies, I have to adapt to the situation). I have the following defintions: Firebird BLOB field is defined as: BLOB SUB_TYPE 0 SEGMENT SIZE…
TomR
  • 2,696
  • 6
  • 34
  • 87
0
votes
1 answer

Is it possible to backup Firebird DB when using SuperServer on Windows Server 2016?

When I execute Firebird 3.0.x backup command: c:\Db>"C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b c:\Db\Db1.fdb c:\Db\Db1_backup.fbk -garbage_collect -transportable -verify -user SYSDBA -pas PASSWORD Error 1 happend: gbak: ERROR:I/O error…
mojmir.novak
  • 2,920
  • 3
  • 24
  • 32
0
votes
1 answer

Specify firebird connection dialect, not database dialect

I have a Firebird database which is using Dialect 1. Some old Delphi apps MUST have it using Dialect 1 or certain queries will fail. The issue is, I'm using ColdFusion to communicate with the database for our web applications and it needs Dialect 3.…
Phil
  • 4,029
  • 9
  • 62
  • 107
1 2 3
…
14 15