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

Can't connect to Firebird 3.0 with user with small letters in login with Java

I connect with names in capital letters, but it does not want to connect with small letters in the login. Here is a small test String ENCODING = "WIN1251"; String CONNECTION_URL = "jdbc:firebirdsql:localhost:C:/ProgramData/test.FDB"; Properties…
Алексей Самойленко
  • 31
  • 5
1
vote
1 answer

Firebird SQL join recommendation

I am using Firebird 3.0. I have 2 tables and I want to get the following result with one query, but I couldn't do this. USERS Table ID USER_NAME 10 User1 20 User2 30 User3 40 User4 50 User5 CALL_HISTORY…
nakisen
  • 13
  • 3
1
vote
1 answer

TIB_Script run large script

I encountered a problem that IB_Script returned an error while running a longer script: SQL Error Code = -104 Unexpected end of command - line 18, column 52 As long as the number of characters in the script did not exceed 65,536 characters…
Himer Norbert
  • 41
  • 5
1
vote
1 answer

Insert values into tables with a foreign key

I want to insert some values in two tables in a loop, but it seems like I can't do it because of the foreign key. However, the same code does work in SQL Server. This works perfectly in SQL Server: declare @i int = 1 while @i<1200 BEGIN INSERT…
Andrzej Szafarczyk
  • 31
  • 4
1
vote
1 answer

ADO.NET FirebirdSql.Data.FirebirdClient.FbException: "Unable to complete network request to host "

I have a pretty strange problem when trying to connect my C# program to an existing Firebird server. First of all, this is reproducable with the default connection example from the Firebird documentation at…
autlunatic
  • 650
  • 7
  • 17
1
vote
1 answer

Computed table column with MAX value between rows containing a shared value

I have the following table CREATE TABLE T2 ( ID_T2 integer NOT NULL PRIMARY KEY, FK_T1 integer, <--- foreign key to T1(Table1) FK_DATE date, <--- foreign key to T1(Table1) T2_DATE date, …
Dragos Dascalu
  • 15
  • 3
1
vote
1 answer

Change the size of a varchar in the RDB$FIELDS table in Firebird

I am trying to change the varchar size of the CODE field of my FAIXA_VALORES table, however when trying to change it with the following code: update RDB$FIELDS set RDB$FIELD_LENGTH = 50, RDB$CHARACTER_LENGTH = 50 where RDB$FIELD_NAME =…
Gxbrielramires
  • 11
  • 3
1
vote
1 answer

Is the cursor variable updated when updating a row?

In the code below (stored procedure body), whether the value of the cursor field is automatically updated after UPDATE or not? If not, is the Close / Open command sufficient again or not? I didn't find any description that included this, it was just…
Himer Norbert
  • 41
  • 5
1
vote
1 answer

Agent start a call when the previous is still in progress

I have a CALLS table with CALL_ID | OPERATOR_ID | CALL_START | CALL_END | NOTES | TYPE ========+=============+=======================+=======================+=======+====== 101 | 3000 | '2020-12-12 08:00:00' |…
L_GIB
  • 125
  • 7
1
vote
0 answers

How to solve Firebird searched case error inside a PSQL function

I need to write a very simple Firebird function create or alter function some_function (A NUMERIC, B NUMERIC) returns double precision as begin return case when (B <= 2.5) then A - 2 when (B <= 5.0) then A - 1 else…
alvaroc
  • 433
  • 5
  • 14
1
vote
2 answers

Firebird default user not set

When I try anything in isql, I get the message: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. unable to open database When I try to create the user I still get the message: C:\Program…
Guido Kleijer
  • 559
  • 1
  • 5
  • 7
1
vote
1 answer

A trigger that triggers a change in a specific field Firebird 3.0

SET TERM ^ ; CREATE TRIGGER ADDPWDHASHHISTORY FOR USERS ACTIVE AFTER INSERT OR UPDATE POSITION 3 AS BEGIN INSERT INTO USERSPWDHASHHISTORY (id, USERID, FIO, PWDHASH, ATTIME) values (gen_id(GEN_PWDHASHHIS_ID,1)…
Marina Vinograd
  • 45
  • 1
  • 6
1
vote
1 answer

Result Set from a TFDScript?

I found some code which works in FlameRobin to return the number of records for all tables in the database but am only able to run it in a TFDScript which works fine but no result set is accessible. I tried various ways in TFDQuery and TFDCommand…
Richard Shuck
  • 113
  • 1
  • 10
1
vote
1 answer

Assign multiple params from single (singleton) select in Firebird?

In a Firebird execute block I want to execute a singleton select and assign multiple columns to a set of parameters/variables. I know a single value can be assigned with :param = (select ...) and that I can also loop through a result set and assign…
Kjell Rilbe
  • 1,331
  • 14
  • 39
1
vote
1 answer

How to inspect nbak state of a Firebird database

Is there a way in C# to inspect the nbak state of a Firebird database? The state in the database header would be set to nbak_state_diff or nbak_state_normal. But how do I actually read this value?
Kjell Rilbe
  • 1,331
  • 14
  • 39
1 2 3
…
14 15