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

How to reset Firebird 3.0 identity column

I am using Firebird 3 for my project and I added identity columns for auto-increment columns. Before publishing it, I tested the database with thousands of records now I want to reset the column back to zero but I couldn't find any solution. Here is…
Core
  • 601
  • 2
  • 7
  • 19
1
vote
1 answer

Delphi Firedac backup Firebird database to local file

Is it possible to use TFDFBNBackup and TFDFBNRestore for creating and restoring backups from/to a remote server from local files? I know that this can be done with the local service manager command line tool like gbak also allows this, but I do not…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
1
vote
1 answer

Copying remote Firebird table to local database

I have a remote Firebird 3.0 server with a database. In this database, there is a big table. The client very often queries this table during their work. There are too many clients and bad internet connection, so the work with this table is terrible.…
Tim Woo
  • 21
  • 3
1
vote
0 answers

Firebird 2.5.8, 3.0.4 unicode_ci_ai index problems

I'm using Firebird 3.0.4 x64 in Linux and Windows, Superserver The databases that I have migrate to utf8 with colation unicode_ci_ai are much slower in use, the problem is the indexes with various varchar fields. example of the problem data: CREATE…
Luis Forra
  • 11
  • 3
1
vote
1 answer

Firebird 3.x error "Attempt to execute an unprepared dynamic SQL statement" in Delphi IBX exception handling?

I am using Delphi 2009 Unicode and Firebird 3.x UTF8/dialect 3 database with IBX components. And now I see that all the exceptions raised from the Firebird SQL procedure and trigger code (e.g. using exception my_exception; statement) are handled by…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
1 answer

Display two unrelated select queries with no mutual fields in one firebird procedure

How to properly display two unrelated select queries with no mutual fields in on procedure? Table1 Number 1 2 3 4 5 Table2 Letter a When i try to call them using this…
Don Juan
  • 155
  • 1
  • 10
1
vote
1 answer

Error in Firebird Procedure

I have to do one query to get one parameter (I need a "1"), but this parameter can be in different cells, for…
Nicolas Oñate
  • 221
  • 2
  • 12
1
vote
0 answers

Character Set ISO8859_1 is not Installed

I have created a C# windows application which is updating a database from Firebird Server to SQL Server. It was successfully running in Visual studio 2015, but when I published(deployed) it and installed in system or others system and when I run the…
Amarnath
  • 113
  • 2
  • 11
1
vote
0 answers

Firebird Entity Framework

I am using Firebird database and newly started with this database so I am implementing with Visual studio 2015. I am accessing a Firebird Embedded database using ADO.NET and my Firebird Embedded database file extension is .CMP. I am successfully…
Amarnath
  • 113
  • 2
  • 11
1
vote
1 answer

Interbase to Firebird Migration

Besides doing a data pump. Is there any other solutions for migrating? Can you take a GBK and restore it to firebird? Is there any other migration issues you may have run into?
John Greco
  • 11
  • 2
1
vote
2 answers

How can I optimize my Firebird SQL query?

Database: Firebird 3.0 This query is used to select records that fit a specific condition, in order to detect which DEVICEID's have bigger LAST_TICK's than what the DEVICEID={INTEGER VALUE} knows of others DEVICEID's Here is the SQL query: select …
Luiz Tessarolli
  • 13
  • 5
1
vote
0 answers

Convert Character Set from WIN1252 to UTF8 - Firebird 3

I'm facing problems trying to convert a Firebird 3 database with character set WIN1252 to UTF8. I've performed the following procedures: Extract the DDL from the database and the definitions, so I created the new database with UTF8 Character Set,…
Marcoscdoni
  • 955
  • 2
  • 11
  • 31
1
vote
1 answer

crosstab: Counting the same string in a field and display it as field name

I would like to have a total of specific string in the field, for this example in the PAYROLL_PAYMONTH field. For example, I will count the number of 'HELLO' in the field and display it in a group. -- DATA EMP_SURNAME PAYROLL_PAYYEAR …
Don Juan
  • 155
  • 1
  • 10
1
vote
0 answers

How use new Firebird 3 client API to connect a 2.5 database?

How to setup a DPB to make a client compiled with the new FB 3 API access a remote FB 2.5 database? Is there a way to change WireCrypt and AuthServer in the Database Params Buffer? i.e. IXpbBuilder* dpb = NULL; dpb->insertString (&status,…
Mauricio Junqueira
  • 11
  • 2
1
vote
0 answers

Firebird 3 connection over internet

I have software developed in Delphi with Firebird 3 database that is already ready. I would like to distribute this software to clients without installing the database physically on the client. So the database would stay on my server. I do not like…
Marcoscdoni
  • 955
  • 2
  • 11
  • 31
1 2 3
…
14 15