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

Update all records of a table according to a view result

I have a view like below ITEMNO INCOME OUTGO AA 10 2 BB 15 0 ... so on I'd like to update every record of the ITEMS table (item cards) according to above view's results. I created a stored procedure like below SET TERM ^…
Henry Olive
  • 7
  • 3
0
votes
1 answer

How many days from first day of the current year till today

I'm trying to get day count of from the first day of the current year till today For example: Today = 24/07/2023 FirstDate = 01/01/2023 LastDate = 24/07/2023 The result is 204 days Is it possible to get the result with just a query (no stored…
Henry Olive
  • 7
  • 3
0
votes
1 answer

Connection timeout in Firebird Server 3

I'm connecting to a Firebird SQL Server version 3 with a C# application using Firebird .NET Client 9.1.1. Once the application is started 3 connections to the server are established using a connection pool. When the application quits in a normal…
anli
  • 515
  • 6
  • 9
0
votes
0 answers

Can not connect to firebird databse file in PHP and Apache

I'm using Apache in remote hosting with cPanel. I need to fetch data from a Firebird database file using PHP, so I enabled "interbase" and "pdo_firebid" modules. I execute connection to database file code, but it's not working. $dbh = new…
Bahmed Boussada
  • 11
  • 3
0
votes
1 answer

Power BI Dataset can not find Firebird database

After a Firebird 3.0 update, our PowerBI Dataset can't find the Firebird database, although the ODBC Setup works just fine. But the most bizarre part, I can create a new Dataflow-set with the exact same data source (same Gateway to ODBC Source)…
SCTHOLD
  • 1
  • 2
0
votes
1 answer

Firebird Server 3.0 not run automatically after installation

I have used Firebird setup 3.0 (Firebird-3.0.10.33601_0_Win32.exe) witch the parameters: Firebird-3.0.10.33601_0_Win32.exe /SILENT /NORESTART /COMPONENTS="ServerComponent,ServerComponent\SuperServerComponent,DevAdminComponent,ClientComponent"…
sed47
  • 31
  • 2
0
votes
2 answers

Try to connect a Firebird 3.05 Database to Python (pandas)

I am trying to connect a Firebird database with Python. I already tried it with pyodbc: import os import pyodbc server = '127.0.0.1/3050' database = 'Databse-Name' username = 'Username' password = 'password' cnxn =…
Volker Aizpún
  • 1
  • 2
0
votes
0 answers

Firebird dump tables

I have a database.gdb running with Firebird 3.0. This database has two tables: Table1 and Table2. Every day I add records to these tables and when I have finished my work I need to export the two tables to another newer database. I need a…
IronButterfly
  • 1
  • 2
0
votes
1 answer

Commit/Rollback transaction not listed in MON$TRANSACTIONS

We have a strange issue in a customer's Firebird database. We noticed an active transaction not listed in the mon$transactions table. According to the gstat utility, transaction 231.768.260 is active: However, running a simple SELECT * FROM…
TiagoTecchio
  • 308
  • 3
  • 9
0
votes
1 answer

Get value from Firebird cursor by field name

I need get data from cursor by field name, stored in var. For example, I have statement: for select CUBE1, CUBE2, CUBE3, ....., CUBE31 from GET_DATA(......) B where ..... as cursor cvol do And now I need get value from cursor by dynamically…
Evgeny
  • 3,910
  • 2
  • 20
  • 37
0
votes
0 answers

Firebird 3 connection string not working in C#

I have a problem after migrating a database from Firebird 2.5 to Firebird 3. The C# application stopped displaying data. I have a 'REPORTER' user assigned to ROLE_SELECT, but not authorized to all tables. I guess the problem is with Fb-Connection…
brian987
  • 1
0
votes
3 answers

Distinct max values or only one maximum value from the serial number

I have a database (with two columns "id" and "serial") with serial numbers. For example: id |Serial 10 | A18D003.000106 12 | A13D002.000100 122| A19D004.000107 There are many more numbers, but let's assume there are about 50 of each type of…
statistics pp
  • 13
  • 2
0
votes
2 answers

gbak gives system directive access failed on Ubuntu when running from net core application

Basically, I want to run a gbak restore (Firebird 3) from my ASP.NET Core application on Ubuntu. Here is my code: string output = ""; using (Process pProcess = new System.Diagnostics.Process()) { pProcess.StartInfo.FileName = "gbak"; …
user2475096
  • 350
  • 3
  • 19
0
votes
1 answer

How to print message in ISQL / IBExpert Sql tool?

I know that in SQL Server we can print message via operator PRINT, but PRINT doesn't work in IBExpert, and command OUTPUT too. Can someone help me? I have this error when I run previous code:
Nika
  • 379
  • 2
  • 16
0
votes
2 answers

'Custom' group by in select

(edited to minimal reproducible example) I needed some help with the following select: Select Id_Product, -- product identifier Sum(Qt_Sold) Sold_Amount, -- total sum of quantity sold Sum(Net_Value) Total_Net_Value, -- total sum of the…
Roberto Henrique
  • 376
  • 3
  • 14
1 2 3
…
14 15