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

Firebird 3.0 embedded DB after new install of Windows 10 with new Username not accessible anymore

I coded a CRM application in Delphi some years ago and worked with it. Now I reinstalled my computer and the only thing that changed was the Username of Windows 10 itself. Result is, that I cannot access the Firebird 3.0 db anymore and I have no…
Andreas Soraru
  • 3
  • 5
0
votes
2 answers

How to get value from table using Firebird trigger

I want to get a value from the table and compare it with inserted value in the Firebird trigger. Here is my code. SET TERM ^; CREATE TRIGGER after_in_systab FOR SYSTEMTAB ACTIVE AFTER INSERT POSITION 0 AS declare sys_code integer; select sys_code…
Zon Ch
  • 21
  • 3
0
votes
1 answer

Updating NULL fields with values

I have a simple table that was populated without complete data and an integer field was not used immediately, so it has over 20,000 null values. I simply want to change every record with a NULL value to 1. The table has only 2 columns, ID and…
Brian Milburn
  • 3
  • 2
0
votes
1 answer

How to make ledger using Firebird database

I want to design Crystal Report from mentioned query, but I'm unable to fetch data from a Firebird database. SELECT TRANSACTION_DATE=null, PARTICULAR='Opening Balance', DEBIT=null, CREDIT=null, sum(DEBIT)-sum(CREDIT) as balance FROM ROZNAMCHA WHERE…
Zon Ch
  • 21
  • 3
0
votes
0 answers

How to remove Firebird's triggers created automatically

How to remove Firebird's triggers created automatically? I've got an error: SQL> drop trigger CHECK_4; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -DROP TRIGGER CHECK_4 failed -Triggers created automatically cannot be…
volkoshkursk
  • 325
  • 1
  • 2
  • 14
0
votes
1 answer

What's wrong, I cannot create this table

That's my first time using Firebird. I am trying to create this table. I checked the docs and it seems ok. What's wrong? CREATE TABLE ENDERECO ( ID_ENDERECO INTEGER generated by default as identity primary KEY, RUA VARCHAR(50), …
Diego Alves
  • 2,462
  • 3
  • 32
  • 65
0
votes
0 answers

Grouping issue in computed column to display days passed since last update, returns a "multiple row in singleton select" error

As a followup question to Computed table column with MAX value between rows containing a shared value , Considering the following tables and values: T1ID T1DATE T2ID FK_T1ID T2DATE 1 01/03/21 1 1 …
Dragos Dascalu
  • 15
  • 3
0
votes
1 answer

Relationship of 3 fields

I have 2 tables: Table: PatientsUpdates Table: TextMaster I need the final result: The final result is the current status of all patients of the gender reassignment surgery section in a hospital, but title of a patient's name is selected from…
Nukool
  • 25
  • 7
0
votes
1 answer

Trailing zeros appears after casting DOUBLE PRECISION to VARCHAR

When trying to cast a DOUBLE PRECISION value to VARCHAR, I get a serie of 12 undesired trailing zeros. For example: SELECT CAST(CAST(2500 AS DOUBLE PRECISION) AS VARCHAR(50)) FROM rdb$database It produces the following unexpected…
Fabrizio
  • 7,603
  • 6
  • 44
  • 104
0
votes
1 answer

How do I display a whole number in Firebird?

I am calculating an average in Firebird, and need only the whole number as a result. By using the "TRUNC" function I can get the number to display "99.000", but all I want is "99". I cannot find anything in the Firebird 3.0 language reference guide…
Bruce Reirden
  • 13
  • 2
0
votes
1 answer

FirebirdSql.Data.FirebirdClient connecting with a user other than Sysdba - username and password are not defined

I use FirebirdSql.Data.FirebirdClient to connect to a Firebird database (WPF desktop app). Server Version: WI-V3.0.5.33220 Firebird 3.0, and ADO.net provider version is 7.5.0 (NuGet) I created a user other than SYSDBA that only has read only access…
dsungaro
  • 148
  • 1
  • 11
0
votes
1 answer

How to optimize SQL delete query with subselect for Firebird?

The following query is extremely slow. It seems the subselect is executed for each row in the table?! delete from HISTORY where ID in ( select ID from ( select ID, ROW_NUMBER() over(partition by SOURCE order by ID desc) as NUM from HISTORY )…
maf-soft
  • 2,335
  • 3
  • 26
  • 49
0
votes
0 answers

How to fix IBPP::LogicException: Unknown or unsupported statement type?

I'm working with C++ API for firebird database. I can connect with the database, but when I try to execute an statement, I get this error: *** IBPP::LogicException *** Context: Statement::Prepare Message: Unknown or unsupported statement type The…
Levy Mateus M.
  • 1
  • 1
0
votes
1 answer

How to measure prepared statements memory size in Python?

We are migrating data from a Firebird database using Python FDB to Azure SQL using pyodbc. There are many tables, and we could generate a Polybase workflow for each one, that is more work with many benefits. However, I would like to see if we can…
Dan
  • 2,209
  • 3
  • 23
  • 44
0
votes
1 answer

Variables in queries Firebird 3.0

This query does not work select a.id from users a where a.LOGIN = 'Test' into :useriden WITH T AS ( SELECT ID, FIO, PWDHASH, ATTIME, ROW_NUMBER() OVER(ORDER BY ATTIME DESC) AS RN FROM USERSPWDHASHHISTORY WHERE USERID =…
Marina Vinograd
  • 45
  • 1
  • 6
1 2 3
…
14 15