3,849 questions
0
votes
0
answers
14
views
Firedac not replacing images in firebird database
I am trying to replace images in a firebird database using Firedac and delphi 11. All fields do get updated but the image fields IMAGE and IMGTHUMB do not change.
When adding new records the similar ...
0
votes
1
answer
22
views
How to log in with user SYSDBA on a Firebird database that has the role SYSDBA
I need help bypassing Firebird 2.5 error. The error is
Your login SYSDBA is same as one of the SQL role name. Ask your
database administrator to set up a valid Firebird login.
[SQLState:28000, ISC ...
- 21
0
votes
1
answer
27
views
Linq2Db Firebird - violation of FOREIGN KEY constraint although in transaction
I have a department tree hierarchy in firebird I do CRUD on. At least I would like to. Using Linq2Db and the firebird provider I cannot insert into the table without getting the error: violation of ...
- 423
-3
votes
0
answers
62
views
Django and Firebird [closed]
Has anybody a running system using Django and Firebird?
I have installed all development tools as recommended. Currently I am back to python:latest (3.13.0) and installed django (5.1.13). I also use ...
- 23
0
votes
1
answer
40
views
Data on the number of connections in Firebird is not displayed correctly
On the project there are many databases in the form of files for Firebird. I need to know the number of connections to the database.
There are about 100 databases and I would like to have statistics ...
- 13
1
vote
1
answer
31
views
Set generator to value of another generator
I want to set the value of the generator Dest to the actual value of generator Src:
ALTER SEQUENCE Dest RESTART WITH GEN_ID(Src, 0);
This doesn't work:
Invalid token. Dynamic SQL Error. SQL error ...
- 174
0
votes
0
answers
34
views
Firebird 5.0.1 closes applications and requires reboot
In our application we use Firebird as a database. An install-launcher program (a simple win32 program) performs a scripted installation of Firebird, then of the main application, by calling both ...
- 676
0
votes
0
answers
92
views
Issue with concurrent database calls Using ZeosLib
I have a problem with a function that interacts with the database. When I call it sequentially, it works perfectly, but when I call it concurrently, it gives me an error.
Is ZeosLib not thread-safe, ...
0
votes
0
answers
58
views
I have an issue setting up the Firebird 5 ODBC driver connection in Windows
I currently have multiple Firebird databasis on my Windows PC running on Firebird 2.5 and Firebird 3. We are moving over to Firebird 5 and I'm struggling to get the Firebird ODBC 3 driver set up.
I ...
0
votes
1
answer
45
views
Why is there no SQL statement in MON$STATEMENTS.MON$SQL_TEXT for all active transactions in Firebird 2.5
I am trying to find the SQL statements for my active transactions and specifically for OAT.
I am running this query:
select MT.MON$TRANSACTION_ID,MT.MON$TIMESTAMP,MS.MON$STATEMENT_ID,MS.MON$SQL_TEXT
...
1
vote
1
answer
70
views
Error "Conversion error from string " . . : : "." (335544334) when trying to add another column
Given is a Firebird 5.0 table with this DDL:
CREATE TABLE KASSE_DETAILEDSTATISTICS
(ORDERDATE KASSE_ORDERTIMESTAMP NOT NULL,
PRODUCTID KASSE_PRODUCTID NOT NULL,
CONSUMPTIONPLACE KASSE_INHAUS ...
- 170
1
vote
1
answer
78
views
Error in a PHP PDO connection with Firebird 2.5
I'm trying to connect and get some data from a Firebird 2.5 database. I use PHP 8.0.30 with XAMPP.
$query = "SELECT FIRST 2 PG.PRODUTOGRADE_IDENTIFICADOR AS ID, P.PRODUTO_DESCRICAO AS PRODUTO, ...
- 11
0
votes
0
answers
64
views
Firebird Server Installed but no Firebird Service
I downloaded Firebird 2.1.7 tar file. Installed with install.sh. I can connect to the db at /opt/firebird/bin/isql, but how do I set it up as a service? There is no Firebird service and no instruction ...
- 118
1
vote
1
answer
126
views
How to deploy a Visual Studio application and install Firebird as a service in silent mode?
I should deploy my own C# application that uses Firebird as database server and remote connections. Which files should I distribute and execute during installation so that the end user does not have ...
- 55
1
vote
2
answers
88
views
how to set connection timeout on remote firebird?
With my Xamarin Forms app I connect to a Firebird database on my Windows PC when I'm on the same WiFi network by the IP address. This is the connection string:
@"Server=" + ipaddress + @&...
- 55
1
vote
1
answer
58
views
How to exclusively select a record from different tables
I am stuck with a SQL problem - I hope you can help me. DBMS is Firebird.
I have two tables containing addresses, both very similar in layout.
One table contains the main address (main_addr) where the ...
- 192
2
votes
1
answer
40
views
How to get the complete DDL stored procedure (input/output parameters and body) in Firebird 2.5
I am trying to retrieve a complete DDL stored procedure from Firebird 2.5 database but the result is incomplete.
The original stored procedure source code is:
SET TERM ^ ;
create or alter procedure ...
2
votes
1
answer
59
views
How to use a WHERE ... IN ... clause with parameterized arrays in node-firebird?
I'm writing an SQL query using node-firebird with a WHERE ... IN ... clause and a parameterized array, like this:
SELECT * FROM MY_TABLE WHERE MY_FIELD IN ?
And passing the parameter:
[['string1', '...
- 163
0
votes
1
answer
114
views
Multi-insert statement in INSERT command
I have to download the data residing in a SQLite database in my Xamarin app into a Firebird database which is on my PC on the same WiFi network and I reach with IP address. Everything works correctly, ...
- 55
1
vote
1
answer
58
views
How to extract one specific table from many Firebird 2.5 database backups?
I have a bunch of backups of the same Firebird 2.5 database. I restored them using this batch:
rem @echo off
C:
cd "C:\Program Files\Firebird\Firebird_2_5\bin"
gbak -c -user SYSDBA -password ...
0
votes
1
answer
71
views
Unable to backup firebird database file locked
We are using Windows 11 and a Firebird 2.5 database engine.
We have three locations that all use the same version of Firebird. We have an automatic backup routine that runs daily to create a zipped ...
- 149
0
votes
2
answers
73
views
Firebird SQL add empty rows in resultset
How to add empty rows in Firebird SQL Select resultset.
I can create Select, and the select resultset before add 12 empty rows.
1st probe:
select * from table where id like 'R%'
union all
select null,...
- 3
0
votes
2
answers
102
views
SQL grouping result to half hour
I have a Firebird 2.5.9 database and I need to work on two tables. The first one stores a date and operation time. The date is stored as DATE field and 3 other fields as string (char) for year, month ...
- 53
0
votes
0
answers
33
views
Dependent tables replications using Kafka
We need to replicate near 120 Firebird (FB) tables to Postgres with foreign key constraints. FB doesn't support CDC.
As I understand only JDBC driver can be used for this purpose. We can use increment ...
0
votes
1
answer
226
views
FireDAC Firebird Connection rejected by remote interface
I use Delphi 10.4.2. I downloaded the examples.fdb ( 3.0 ) directly for Firebird.org.
When I click on Test I instantly get a [FireDAC][Phys][FB]connection rejected by remote interface.
I am stuck. ...
- 375
2
votes
1
answer
52
views
How to define "Remote process" for Tomcat connection in Firebird
I am writing a web service project with Eclipse, connecting to Firebird database using Tomcat 8 server. Problem is in IBExpert tool, connections from Tomcat show null value in "Remote Process&...
- 154
0
votes
0
answers
36
views
PHP Firebird unable to locate
I'm not being able to locate the pdo_firebird, even tho the file is in the correct directory.
Error message:
PHP Startup: Unable to load dynamic library 'pdo_firebird' (tried: C:\php-8.2.22\ext\...
0
votes
0
answers
68
views
Firebird-Postgres replication using Kafka
We have a bunch of sql queries running once a day to replicate data from Firebird to Postgres. I am working on moving this ETL process to Kafka. Some tables are large and requires immediate ...
1
vote
0
answers
71
views
LibreOffice Writer doesn't import Base query fields containing LIST()
I have a query in LibreOffice Base (Firebird) which uses the LIST() function. It works perfectly fine, but when creating a Writer document with database fields utilizing this particular query, it ...
- 37
0
votes
0
answers
109
views
Firebird + SQLAlchemy: non-latin symbols in path to db
I'm trying to open a Firebird database with cyrillic characters in the path, something like this
path_to_fdb = 'D:/базы/mydb.FDB'
db_url = f'firebird+fdb://sysdba:masterkey@localhost/{path_to_fdb}?...
- 25
0
votes
1
answer
48
views
How can I simplify two selects
Is it possible to simplify two selects, maybe into one as they add a bit of time when used in a stored Procedure and called many times?
/* Get Our OVER Spent Codes */
select SUM(Cmt.BALANCE_TD)
from ...
- 165
0
votes
0
answers
127
views
How to make dynamic reports with a Firebird DB?
I have a large Firebird database containing details of thousands of individual custom product orders. What are the best options to create reports of these orders that can be filtered and sorted? We ...
- 1
0
votes
0
answers
46
views
How to solve error invalid request BLR at offset 68 input parameter mismatch for procedure ZP_CHECK_FORMAT_INSERT
I have the following error in the Firebird Database. version 2.5.2
invalid request BLR at offset 68
input parameter mismatch for procedure ZP_CHECK_FORMAT_INSERT
How can I debug this problem? Anyone ...
0
votes
0
answers
31
views
Combine two queries into columns if join breaks grouping and union combines into rows [duplicate]
how do I combine the results of these queries into columns? join is not suitable, because then in the on condition you will need to compare the id and the grouping will be broken, and union joins into ...
- 49
0
votes
2
answers
108
views
Get rows as a result of a non-null query and at the same time count the number of rows by columns that did not hit but they are also not null
I want to take all records into account when calculating the count for num_zaprosa and num_otveta, but not show them in the result set if one of them is null. Is it possible to do this? here is my ...
- 49
2
votes
0
answers
135
views
Improve Linq2Db result mapper performance
Is there a way to improve the performance of the ORM mapper of Linq2Db using the FirebirdDataProvider. I retrieve 1831 records from a table having 39 columns (all INTEGER, DECIMAL(13,5) and 2x VARCHAR(...
- 423
0
votes
1
answer
44
views
ADO.NET Firebird remote backup-restore file cleanup
I am using Firebird with ADO.NET provider to backup/restore a database on a remote server.
This is creating a temporary .bak file on the server which I'd like to delete after completion.
Is there a ...
- 1,885
1
vote
1
answer
222
views
Hibernate generates not correct SQL concerning subqueries with IN clause
Today I ran into an issue with Hibernate 6 and Firebird 4 database which is best demonstrated by the following query:
select * from rdb$relations
where rdb$relation_id in ((select rdb$relation_id ...
- 102
1
vote
1
answer
65
views
Subselect in double parentheses leads to multiple rows in singleton select error
I ran into a strange behavior in Firebird (Firebird 4 and Firebird 2.5 as well) using the following example query:
select * from rdb$relations
where rdb$relation_id in ((select rdb$relation_id from ...
- 102
-1
votes
3
answers
72
views
Filter rows in SQL query when a subquery returns null
I have a problem with subqueries. I'd like to select rows which contain a sum from a different table - so far no problem. However I'd like to filter for rows that don't have sum.
Example: Table1 has ...
- 192
0
votes
1
answer
175
views
FlameRobin unable to connect to Firebird4.0
I have FlameRobin 0.9.3 installed on a Windows machine. I can successfully connect to Firebird 3.0 database running on CentOS
Now I have another Firebird 4.0 database on a separate Almalinux machine ...
0
votes
1
answer
49
views
Why can't Firebird 3 perform where in?
When the code below is executed, it keeps thinking forever and ends up crashing fastreport, why?
SELECT TREQDEVMAT.COD_PRODUTO,
TPRODUTO.DES_PRODUTO,
TPRODUTO.COD_SUBFAMILIA,
...
- 23
0
votes
0
answers
57
views
Firebird Hibernate Dialect generates CONCAT, which is not valid syntax
Specification: Firebird 2.5, Hibernate 6.2 or 6.5 - yes I know this is odd composition since Firebird 2.5 is pretty outdated but for a while I have to live with it.
When I call custom method in ...
- 55
1
vote
1
answer
146
views
Firebird Hibernate dialect misplaces first ? and skip ? parameters in statement
Configuration: Firebird 2.5, Hibernate 6.2 or 6.5
When I call custom method in PagingAndSortingRepository with Pageable object set to page > 0 the generated statement has misplaced first and skip ...
- 55
0
votes
0
answers
73
views
Write to a Firebird DB using Power Automate
I want write to a Firebird database (.fdb) using Power Automate. How can I make it possible?
I have a table with a list of products with the price in Power Apps. The user can change the price, and I ...
0
votes
1
answer
60
views
Migrate stored procedure from Firebird to Oracle
I have some stored procedures in Firebird that I need to migrate to a new database in Oracle. Here's a simplified example of one of them:
create or alter procedure CALCULA_ARTIC (
FECHA_INICIO ...
- 21
0
votes
0
answers
83
views
Wait until column value changes in Firebird 4 UDR
I need to return some information in a stored procedure, but to get the information in this stored procedure, I need to wait a column to be changed in a specific table. For example:
Table Structure:
...
1
vote
2
answers
410
views
Embedded Firebird in .Net 8.0 (x64) not working
I am trying to connect to an Embedded firebird database using a .Net 8.0 application.
I create a connection string to an existing database as follows (in server mode) :
datasource=localhost;database=C:...
- 1,885
0
votes
0
answers
116
views
ODBC Firebird driver not yet implemented
Is there anyone who experienced this error?
SQLSTATE = HY000 [ODBC Fire bird driver] not yet implemented.
What could be the reason why I encounter this error?
Any recommendation how I can solve this?...
- 1
0
votes
0
answers
64
views
How to move numbers on a number line?
I have a Firebird 3 table like this:
MyTable
-------
ID: Integer (auto inc), primary key
Pos: Integer, Unique
Flavor: varchar
Data looks like:
Pos Flavor
-------------
1 Chocolate
2 Vanilla
3 ...
- 174