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

Round to the next tenth, subtract 0.02

I have an ITEMS table with a PRICE column. I added 4% to the price using the built-in functions in the application, but that leaves the result not in a friendly formats for retail. I want all the prices to end with 8 (so $24.93 becomes $24.98) I…
john castaldi
  • 21
  • 1
2
votes
0 answers

How can I post updates for deleted records using TEMSDataSetResource in RAD Server 11

I have created a simple new Rad Server Package with resource with a data module to access a Firebird 3.05 database running on Ubuntu 18.0.4. I included sample endpoints and a database endpoint with one table from the database. I modified the created…
Randy Sekura
  • 21
  • 2
2
votes
2 answers

How to configure firebird 3.0 or set rights so any user can create a DB

I followed this guide for firebird3.0 on ubuntu. It is outdated, since there is no more employe.fdb in the examples and you have to create it itself through the included sql script. My problem is, that I can only create this database if I use…
Namal
  • 281
  • 2
  • 10
2
votes
1 answer

Delete empty lines in a text blob

I have a list of email addresses in a table called cc_list (blob(text)). To remove an email address from the list, I have used the replace function update actions set cc_list=replace(cc_list,'email@bob.com','') where contact_id=85 Now, the list…
L_GIB
  • 125
  • 7
2
votes
1 answer

FirebirdSql Data Client I/O error during "CreateFile (open)" operation for file

One of our clients is getting this error very randomly. Once or twice a week. It has only been happening for the last month or so. Error message: I/O error during "CreateFile (open)" operation for file "ttt" Error while trying to open file Stack…
Netstrata
  • 75
  • 1
  • 7
2
votes
1 answer

Firebird Unable to complete network request to host

Getting this error message randomly from our .Net Core Web Application. There's no problem with connecting. But in the middle of performing a job to grab some report data which can take anywhere from 10 seconds to 50 seconds we occasionally get this…
Netstrata
  • 75
  • 1
  • 7
2
votes
1 answer

Firebird connection string not working post Firebird 3 migration

I have a regression with a TCP\IP connection string post a firebird 3 migration from v2.5. The FirebirdClient version is 4.6.1 but I've tested with the latest stable version and it also doesn't work (v7.10.1). The error message is "Your user name…
Netstrata
  • 75
  • 1
  • 7
2
votes
2 answers

How to get sum of detail table fields in master table with update trigger

There are master table 'factgad' and detail table 'recgad' in a Firebird 3.0 database. factgad: factgad_k(pr_k)... recgad: recgad_k(pr_k), factgad_k(fk)... When I update the master table, I have to get sum of detail table's records, but I couldn't…
basti
  • 399
  • 2
  • 10
2
votes
1 answer

I can log into a Firebird 3 database with any user and password

In a newly created database, I don't get any error message when I log in with the wrong user and password (the users TTT and AAA don't even exist) [root@fewww bin]# ./isql /opt/db/treewww/ftree.db -user ttt -password bbb; Database:…
Haik Hairapetyan
  • 23
  • 3
2
votes
1 answer

Firebird Missing user management plugin

When I try to open User Manager or just simple do a select * from sec$users, I get an error Missing user management plugin. I have already seen in some posts how to set usermanager from firebird.conf adding Srp, Srp256, Legacy_UserManager and…
Fernando Donizeti Ito
  • 33
  • 7
2
votes
1 answer

Firebird user has all access rights on a single database except cannot create new db and no access to other database

I have a server that will manage multiple Firebird databases. My users are allowed to have full access on all the objects for a single database but they are not allowed to create new database and no access to other databases in the same server. How…
Sherlyn Chew
  • 189
  • 1
  • 2
  • 8
2
votes
3 answers

How to format an output in a CSV file using isql Firebird 3.04?

I wrote the following script to select data from a database and save it in a CSV file using isql: OUTPUT temp/filename.csv FORMAT csv DELIMITED BY ';'; SELECT dept_no, department, location FROM department; I got the following result in the CSV…
Aigerim
  • 71
  • 1
  • 5
2
votes
1 answer

Create user fails in Firebird 3 with isql-fb

I am trying to create a user in a firebird 3 database (on Fedora 27). When I connect to my database with isql-fb with the role RDB$ADMIN, I cannot create new users. [user@host]$ isql-fb -z ISQL Version: LI-V3.0.3.32900 Firebird 3.0 Use CONNECT or…
mor22
  • 1,372
  • 1
  • 15
  • 32
2
votes
1 answer

Firebird 3 SQL windows function over()

I need help.. I have table orders like this id,order_date,price,customer_id 1 01.01.2001 100 1 2 01.02.2001 0 1 3 20.02.2001 0 1 4 04.04.2001 200 1 I need select result like this id,order_date,price,customer_id,somefield 1 01.01.2001 100 1 …
Tester2019
  • 21
  • 1
2
votes
4 answers

Recursive Relationship on Dictionary Table

I'm working on a poor, but ok for us, full-text search using only PSQL in Firebird. I'll try to simplify as much as possible by focusing on my problem: Summing up, this a dictionary table: SELECT * FROM FTS_KEYWORDS ID | KEYWORD ----+----------- …
dipold
  • 787
  • 8
  • 18
1 2
3
…
14 15