Most voted "firebird" questions
Firebird is a relational database management system based originally on the code of another relational database management system, Interbase. In its version 6.0, Interbase had its open source for the community that created the Firebird project.
Learn more…347 questions
Sort by count of
-
13
votes7
answers180098
viewsFormat decimal places directly in the SQL command in Firebird
I have a table ESTOQUE containing a field called QTDE, this field has 3 decimal places. What would be the command to return directly from SQL formatted with 3 houses? Because the integer values are…
-
12
votes2
answers23371
viewsHow does the BLOB field work?
Hello, directly asking, how does this kind of field work? I know there are three types: BLOB = 64KB, MEDIUMBLOB = 16MB and LONGBLOB = 4GB Given this example: CREATE TABLE COMPROMISSOS ( ID INTEGER…
-
9
votes1
answer667
viewsFirebird SQL and Union ALL without duplicating items
I have an appointment SQL searching in two table one leading and one of historical only when I run the query the values come duplicated I use UNION All because if I put the UNION or DISTINCT…
-
9
votes1
answer344
viewsWhat is the difference between Collation UNICODE_CI_AI, UNICODE_CI and UNICODE
There is a difference between UNICODE_CI_AI, UNICODE_CI and UNICODE? What they are and what they interfere with in the database?
-
7
votes2
answers3607
viewsWhat is the difference between using GDS32.dll and fbclient.dll and using . fdb and . GDB in Firebird?
Speaking of SGDB Firebird, when using the library GDS32.dll, other than compatibility with banks created by Interbase, there are other differences when using the fbclient.dll? There is a difference…
firebirdasked 10 years, 2 months ago user3628 -
6
votes1
answer306
viewsC# application with Firebird connection error on Windows 7 32/64 bit with 2GB RAM
Hello! I am developing an application in C#, in which I have already installed it in several machines for testing with windows Xp, 7 and 8 and in all of them the application worked correctly, but in…
-
6
votes1
answer3105
viewsselect with limit in Firebird
I do in mysql to fetch the 1000 last regions: select * from tabela order by id desc limit 1000; Now, how do you do it in the Firebird? doing so have the following error message: Dynamic SQL Error…
-
6
votes1
answer483
viewsMigration, Delphi and Firebird. What is the correct way to deal with the Encounter issue?
I have a project in Delphi 7 that makes use of Firebird. I think about migrating this application to a Delphi XE version*. However, we know that from Delphi 2009 the String standard is Unicode and…
-
5
votes2
answers3382
viewsReceiving error: "Your login SYSDBA is same as one of the SQL role name" while trying to access base with Ibexpert
I need to access the data from a Firebird database (.FDB), but when trying to access this database using Ibexpert I get the following error: "your login SYSDBA is same as one of the SQL role". In…
firebirdasked 9 years, 6 months ago Rafael William 51 -
5
votes1
answer95
viewsConcatenate two sql
I have the records: |DT_OBS | DESC_OBS | COD_TURNO | COD_PERIODO| |01.10.16| TESTE 01| 1 | 1 | |01.10.16| TESTE 02| 2 | 1 | |01.10.16| TESTE 03| 1 | 2 | |02.10.16| TESTE 04| 1 | 1 | |02.10.16| TESTE…
-
5
votes2
answers10554
viewsSelect with "different" expression with two conditions
I wonder if there’s any way to make a select using a where for a field with the parameter other than < >, where it has two or more items. To facilitate follow example: select * from…
-
5
votes1
answer522
viewsHow to Change Server Type in Firebird 2.5 (- Superserver, Classicserver or Superclassic)
How to Change Server Type on Firebid 2.5? I know it’s three : Superserver, Classicserver or Superclassic
firebirdasked 6 years, 10 months ago Edu Mendonça 2,564 -
4
votes2
answers690
viewsWhat is the cause of using SELECT null FROM RDB$DATABASE
I don’t understand this SELECT null FROM RDB$DATABASE: SELECT CK.IDCHEK, CK.DESCHE, (SELECT null FROM RDB$DATABASE) AS ENTEGU FROM TC_CHECKL CK ORDER BY CK.IDCHEK It looks like it goes in an…
-
4
votes1
answer1716
viewsHow to separate text words from a comma column?
There is a ready function in Firebird 2.5 that is the inverse of the list function? When you make a select list(campo,',') from tabela is returned all field values in a single line separated by…
-
4
votes1
answer2899
viewsCalculation of dates in Firebird
I am created a report to demonstrate the period of removal of employees, for that I need to calculate the days, months and years that the same stayed away, and I’m having a problem, in Firebird use…
-
4
votes2
answers7173
viewsFirebird SQL auto-increment
I’m taking an SQL/Modeling course in mysql the creation of a composite table would look like this: USE banco; CREATE TABLE clientes( cli_id integer not null auto_increment, cli_nome varchar(20) not…
-
4
votes2
answers1998
viewsOpen xls (password protected) file in Delphi and save data in Firebird table
I have an office file (.xls), password protected, which has several lines. I want to search the contents of the column 1 and knowing the row that the result is found I want to save this single row…
-
4
votes1
answer795
viewsUse Execute block in SQL
Is there any way to search two fields (in different tables), compare them and if they are different perform an update? Could you give me a brief example if there is any way, using the EXECUTE BLOCK.…
-
4
votes1
answer624
views"The resultset is closed" error with Preparedstatement
I’m getting it when I’m walking through a ResultSet and get other ResultSets: public class BpaDetDao extends DaoAbstract<BpaDetBean> { public static final String // TODO Colocar campos no…
-
4
votes3
answers19925
viewsFirebird, native date format function
There is a native Firebird function that formats the date(date)? Just as in Mysql we have the DATE_FORMAT() function would have something similar in Firebird?
firebirdasked 8 years, 12 months ago SneepS NinjA 7,691 -
4
votes3
answers5303
viewsFirebird, Insert com Where not exists
I am trying to insert a record into the table, but this record will only be inserted if it no longer exists there, so I am trying to do so: INSERT INTO R01 (NUMERO,EXPORTADOR, IMPORTADOR,…
-
4
votes1
answer1161
viewsHow to set UTF8 charset?
I have a database that was created using Firebird 1.0, at this time there was no UTF8 charset available, only from version 2.0 was having this possibility, so we left the None charset. Doubts: 1°…
-
4
votes1
answer264
viewsCreate select with multiple fields
How to create a select that lists at least 03 tables and presents a field from each table at least ?
-
4
votes1
answer1608
viewsProgressbar and Backgroundworker in C#
I’m creating an app with Firebird 2.5 in which I need her to read a file .sql with instructions to popular the database if it has not yet been done this process, because it is a little long and not…
-
4
votes1
answer75
viewsSql group records
I have the following appointment: select T1.dt_producao, T1.cod_turno, T1.cod_periodo, CASE WHEN T2.TP_PALLET = 'DZ' THEN sum(T1.QT_PROD* T2.QT_EMBALAGEM*12) ELSE sum(T1.QT_PROD* T2.QT_EMBALAGEM)…
-
4
votes2
answers2287
viewsRename table in Firebird
How to rename table in firebird 2.5? I’m using the query: ALTER TABLE cliente RENAME TO clientes;, but error appears: invalid Toke 'Rename'.…
-
4
votes2
answers498
viewsCheck values with 0 included in Count() even if they do not have values
I need to consult the number of banknotes issued with template 55 to create a report. The problem is that I’m needing to put zeroed values in the quantity column even though it has no value at all.…
-
3
votes2
answers5427
viewsHow to extract blob files in Firebird?
I have in a table a field of type BLOB(BLOB SUB_TYPE 0 SEGMENT SIZE 80) where I store some binary files. I need to extract all the files stored in that table. Through Ibexpert in the "Data/Form…
-
3
votes1
answer1477
viewsHow to import Firebird data to mysql?
How to import data from Firebird for Mysql using the PHP?
-
3
votes2
answers1273
viewsHow to bring in the SELECT result the conditions entered as parameters?
Is there any way to bring in the result of SELECT the parameter values used in the clause WHERE ? Example: SELECT a.*, cast(:dataIni as date) AS inidate , cast(:dataFin as date) AS inidate FROM…
-
3
votes1
answer264
viewsRelational model in Firebird with C#
Developing a small C# project with Visual Studio, Firebird bank and ibexpert. With the tables WITHOUT RELATIONSHIP I can perform everything well. But I need to relate CLIENTE 1:N with BONUS And…
-
3
votes1
answer2029
viewsHow to validate Dbgrid fields before saving?
I have a DBGrid, but I want it to validate the fields before saving to the database. I believe I have to use the event BeforePost but I have no idea how to do it. Someone could give me a hint?…
-
3
votes0
answers610
viewsFirebird 3.0 connection problem with Java 1.8
I am having problems trying to connect to Firebird 3.0 using Jaybird 2.2.7, when performing the test with Firebird 2.5 I can make the connection to the database, but when trying to do it with…
-
3
votes1
answer4523
viewsHow do I select in PHP With FIREBIRD PDO?
I have already made a correct connection with Firebird using PHP, however I would like to know how I can make one select in a certain bank. Can someone please help me? <?php $user = "SYSDBA";…
-
3
votes1
answer3182
viewsDuplicate record - Firebird
In Firebird how to delete duplicate records, keeping only one of them? Someone could help me. I have this select, but it deletes all records, use Firebird 2.1 delete from vendaproduto where…
-
3
votes1
answer177
viewsCan you use Firebird by accessing from your Windows Phone?
I developed a C# Windows Forms application with Visual Studio 2013 and Firebird database, but I would like to make a small application to facilitate access to the system. However in this application…
c# .net visual-studio-2013 windows-phone firebirdasked 8 years, 9 months ago André Morais Martins 367 -
3
votes1
answer1420
viewsIs it possible to synchronize a mysql server with a local Firebird database?
I’m new to web applications, and I have a Mysql DBMS-based website. What is the best way to synchronize the web bank with a local bank (the bank being on a fixed ip)? The local bank is Firebird.…
-
3
votes1
answer556
viewsFirebird C# standard Singleton
I am using the following function to connect to the database, I am programming in C# in Visual Studio 2013. namespace WindowsFormsApplication1 { static class Conexao { private static String strConn…
-
3
votes1
answer108
viewsSelect Hibernate + ifrebird
Guys I’m having a mistake in making the select !!! follows the class and error Advertência: #{mbeanUsuario.Vusuario}: javax.persistence.PersistenceException:…
-
3
votes2
answers435
viewsConvert SQL syntax from Firebird database to Postgres database at runtime
I have a system developed in Delphi 7 already stable using the Firebird database, and some customers have requested that they can use Postgres as a database in the same system. As with some…
-
3
votes2
answers1037
viewsHow to close connection to Firebird database
I am doing a project in Asp.net c# web Forms framework 4.5 and I did a test connection to a Firebird database, but when closing the connection it is not closing, I used the following code to open…
-
3
votes0
answers554
viewsHow to copy Firebird fdb database data to gdb
I have a database firebird in format fdb,on it has a table that I want to import to another bank firebird in format gbd. How do I do this process ?…
-
3
votes2
answers2315
viewsNumeric Overflow with Numeric(18,7) in Firebird
I need an accuracy of 7 houses in a given split calculation, but when the divider is very small, it generates an extensive number. When I try to give the cast, it gives Numeric overflow, even the…
-
3
votes2
answers1309
viewsWhy put COMMIT at the end of the script using the Firebird database
Why in the Firebird database everything I do, including creating tables is necessary at the end of the script to give a command COMMIT?
-
3
votes1
answer701
viewsError trying to open *.FDB file in Ibexpert
I need to open a *.FDB file by Ibexpert, until recently I was able to open it normally but yesterday it started giving this error: I already checked the control panel and the BD Firebird is running…
-
3
votes2
answers223
viewsWhich database is ideal for my scenario?
I am developing a commercial automation system (C# and Windows Forms) that can be installed on one or several machines on the same local network. I did the part mobile system, where it is possible…
-
3
votes1
answer662
viewsHow to list each Collation name with its charset - Firebird 2.5
I want to make an appointment involving RDB$Character_sets, RDB$Collations and RDB$Fields in order to obtain a list of "Fields" with their respective RDB$Character_set_name and RDB$Collation_name.…
-
3
votes1
answer467
viewsConnect with Postgresql
I have a file *.ini which connects to my Firebird database, but now I need this file configured to connect to Postgresql [IBConnection] DriverName=Interbase…
-
3
votes2
answers264
viewsJava + Firebird connection returning Null
My connection string with the Firebird database returns null. Follows below code: public class ModuloConexao { public static Connection conector(){ //criação da varáivel conexao Connection conexao =…
-
3
votes1
answer2406
viewsUsing the Firebird SQL case statement
I’m trying to make the following sql in Firebird. select distinct tb_proostarefas.*, (case WHEN (tb_proostarefas.dt_prev is null and tb_proostarefas.dt_vencimento < date) then 1 When…