3,818 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
68
views
How to use SET TERM from Firebird SQL in DataGrip [duplicate]
To work with uni labs I need to write procedures and so that I need to execute given settings script with a command SET TERM ; ^.
Executing this produces this error:
[42000][335544634] Dynamic SQL ...
1
vote
0
answers
114
views
Perform continous data replication on Firebird database with read-only access
My task is to perform continous replication on a Firebird 3.0.5 database. I only have read-only access. The data will go to the Google Cloud Platform, either Cloud SQL or BigQuery.
Read-only means I ...
1
vote
1
answer
72
views
Сonnection timeout for function does not seem to work in Python script
for some reason the connection timeout does not seem to work when connecting to a Firebird database. For example, if an incorrect IP address is specified, the script hangs and waits for a long time.
#!...
0
votes
1
answer
166
views
Delphi FireDAC connect to different Firebird ODS version FDBs concurrently
I have several Firebird databases, some created with Firebird v2.5.9 (ODS 11.2) and some with Firebird 5.0.3 (ODS 13.1.) Both Firebird versions are installed on my VM using different ports, and using ...
0
votes
1
answer
73
views
Passing the selected data from table to C++ UDR function for processing
I am now using C++ for Firebird database UDR Function. The following code is the code for generating a JSON string for Firebird.
I have two tables of Category and Product with following data
CREATE ...
1
vote
1
answer
242
views
Using gbak to upgrade Firebird 2.5.9 database to Firebird 5.0
I have an app using Firebird 2.5.9. We're going to be releasing a major new version of the app, and I want to migrate to FB 5.0. The database schema has changed dramatically between old and new app ...
1
vote
1
answer
152
views
Delphi FireDAC Firebird can't connect to remote FDB
Using Delphi 12.2 Enterprise with FireDAC and Firebird 2.5, I'm trying to connect to a DB via the following code:
type
TFD3Base = class(TDataModule)
dbConn: TFDConnection;
private
FDBHost: ...
1
vote
0
answers
86
views
How to reliably reconnect to Firebird DB with .Net Provider after DB disconnection?
We have a number of C# service type apps that connect to a Firebird database. Occasionally this Firebird DB might be restarted for various reasons, or the network between the Db and the app might get ...
1
vote
2
answers
178
views
Firebird insert record when not exists
If record number 21 does not exist in table1, create them from 21 to 30.
merge into table1 tab2 using table1 tab1 on tab1.number = tab1.number and tab2.number = 21 when not matched then insert (number,...
2
votes
1
answer
104
views
Firebird .NET data adapter: no messages for error message numbers
When using a Firebird 3 database (server), but connecting through a .NET library, FirebirdSql.Data.FirebirdClient (I tried V. 7.10.1 and the newest 10.3.2), I get the following error (in this example, ...
1
vote
1
answer
122
views
TIBBackupService, NULL in MON$REMOTE_PROCESS
We're using Firebird 2.5.9 x64 Windows, Delphi XE4. When doing a backup using TIBBackupService, there is an attachment in MON$ATTACHMENTS, but both MON$REMOTE_PID and MON$REMOTE_PROCESS are NULL. Why? ...
2
votes
2
answers
121
views
Ampersand in select statement returns empty dataset
I have a string field in a Firebird database. The data in some rows contains an ampersand. I'm trying to select the rows but the result is an empty dataset.
Using Delphi 12, FireDAC (TFDConnection + ...
2
votes
1
answer
92
views
Error getting insert ID with RETURNING clause after upgrading to Jaybird 5.0.6
I'm working on upgrading my Firebird database from 3.0 to 4.0. I've completed the migration steps and I'm now testing with my web application and I ran into an issue. I'm using ColdFusion and the ...
0
votes
1
answer
52
views
Triggers execution order inside transaction for change tracking
I have a Firebird table Orders with bunch of columns. I have after update triggers that log table information in events_history table in the following manner:
SET TERM ^ ;
CREATE OR ALTER TRIGGER ...
0
votes
1
answer
97
views
Running multiple Firebird 4 instances creates shared memory error [closed]
I am not big into this whole Firebird configuration thing. I have to run two programs on my Windows machine. They both come with their own version of Firebird 4 (one is version 4.0.2.2816 and the ...