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
-
1
votes0
answers92
viewsPersisisntece.xml configuration with Glassfish datasource
Next people I made 2 glassfish datasources!!!! Where the first is a fixed database!!! Follow picture: This datasource is working correctly !!! My second I do not pass the Database property because…
-
1
votes1
answer110
viewsFirebird - select master-Detail
Hello. I need to make a query to the system tables, which return me the following result: Relation_Name, Field_Id, Field_Name, Field_source, Field_type for each user-defined table (Relation_name)…
-
1
votes3
answers89
viewsSQL - Doubt in a query
Thanks to the help of Motta I managed to arrive in a satisfactory query but I ran into another question because, I need to list only the smallest record for cod, and count the amount of the column…
-
1
votes1
answer46
viewsSQL query using order by filtering by log
I have the table: | cod | hora | produto | Amostra | Min | Max | |-----|-------|---------|---------|-----|-----| | 1 | 08:00 | 96722 | 1 | 100 | 200 | | 2 | 08:23 | 96721 | 1 | 90 | 90 | | 3 | 08:50…
-
1
votes1
answer451
viewsHow to define Generator (from Firebird) for an Entity framework 6 model field?
For example: I have the following table: TABLE_EXAMPLO ----------- ID NAME And the following Generator: TABLE_EXAMPLO_GEN How I would map the entity so that the Entity Framework can call Generator…
-
1
votes1
answer110
viewsSelect in Mysql and Insert in Firebird
How to make a "select" in the Mysql/Mariadb and "Insert" database of the data collected in Firebird().
-
1
votes1
answer241
viewsAccent php - Firebird
I’m making a web module for an old system that uses Firebird. I made the connection using PDO, but when I do a query using some special character it does not return results. If you don’t use a…
-
1
votes1
answer1293
viewsInsert type timestamp into Firebird database
Error in the insert in Firebird database, field DataCadastro type timestamp unaccepted string. INSERT INTO VENDA(CODIGO, NRO_VENDA, DATA_VENDA, VALOR_TOTAL_PRODUTOS, VALOR_ACRESCIMO, VALOR_DESCONTO,…
-
1
votes1
answer107
viewsEntity Framework does not convert Firebird INTEGER to C#long
I am doing some tests with Entity Framework mapping and migrating a database of a legacy system. Setting Where I have a table similar to that: TESTE -------------------------------------- ID INTEGER…
-
1
votes0
answers104
viewsProcedure in Firebird with C#
Good evening I’m new in Firebird, although I’ve handled it a few times, but nothing professional, but now due to a need the embedded solution has been set to use. Well, I am developing a user…
-
1
votes2
answers584
viewsMake a General Sum with all fields
I have the following tables: tb_product, tb_movement COD_PROD | DESCRICAO | TIPO | |01 | CEBOLA | ALIMENTO | |02 | ARROZ | ALIMENTO | |03 | CARNE | ALIMENTO | |04 | COCA-COLA | BEBIDA | |05 | PINGA…
-
1
votes1
answer364
viewsEnable Firebird PDO support for PHP
I cannot install Firebird PDO support in PHP. My machine is running Mac Os Sierra. I have already researched on Pmorts and Pmmebrew and they do not offer support. Some old posts do not explain in…
-
1
votes2
answers2102
viewsCase no order by
I am trying to make an order by as the result of sql: sql.... order by cod_rua, case cod_lado when 'M' then cod_lado desc else cod_lado ASC end, cod_altura Only you’re making a mistake on the way…
-
1
votes1
answer601
viewsHow to synchronize auto increment keys between different databases in Firedac?
I am researching how the auto increment fields work in Firedac, using Delphi xE7 and managed to assemble an example of the documentation that synchronizes two master-details tables with the correct…
-
1
votes2
answers658
viewsHow to optimize Firebird 3?
Someone who works with Firebird 3, do you know exactly how to optimize SGDB to be more efficient? So far I’ve run some tests on Firebird 2.5 and 3 to compare queries, and it’s pretty much the same.…
-
1
votes0
answers178
viewsApplication Delphi 10 Seatle does not open
I am developing an application in Delphi 10 Seatle with bd Firebird and it compiles and runs normally. But when you put it on another computer it gives an error and the memory address appears. If I…
-
1
votes1
answer152
viewsFirebird GEN_ID() function equivalence in ORACLE
Speak guys, I’m starting learning with BD Oracle, before I used Firebird. However I’m having a problem that I’m not able to solve. I can not include a new country by the system (java), if I insert…
-
1
votes1
answer136
viewsMigration with Strange Characters?
The data is from a bank Firebird and even opening with official tools the characters do not come in the "format" br, for example: ÁGUA vem µGUA PÃO vem PÆO Find a website that provides a special…
-
1
votes2
answers202
viewsSQL query with duplicate items
I have this situation and do not know why it happens. When I pass this SQL command the displayed items comes duplicated. What should I do to appear one item each without putting the DISTICT SELECT…
-
1
votes1
answer327
viewsHow many percent N item represents in the overall total - Query
Good morning, I’m creating an ABC curve report but I’m beginner and I’m still having some difficulties. I have a table called ITEMS. With fields: COD_ITEM, Quantityevenda, Valorunitario, Subtotal,…
-
1
votes1
answer345
viewsCompare End Date of the first record with Start Date of the second
Hello. I’m having trouble drafting a SELECT that checks whether the End Date of the first query record is greater than the start date of the second. The database in question is of notes and for some…
-
1
votes1
answer1810
viewsHow to convert dates into varchar to date in SQL `Firebird`?
How to convert dates into sweep for date? I’m having difficulties in performing searches between dates, due to this discrepancy in the database where I perform the query. When I enter my line of…
-
1
votes3
answers4627
viewsHow to return empty record from a Select?
I’m creating a system in PHP and in it has a Script which selects the data of the module requested by the user. The Script creates the form to view and edit the data according to the information of…
-
1
votes1
answer768
viewsSQL Delete with Join, Union in Firebird
What would an Example of SQL Delete look like with Join or Union? I saw here in stackoverflow how to do in Mysql in sql Server more in Firebird I did not find or found in other forums. my SQL looked…
firebirdasked 7 years, 4 months ago ProsTecnologia 560 -
1
votes0
answers167
viewsError doing Linked Server with Firebird Database
I installed Firebird 2.5 and the due ODBC driver on my computer. I tested the connection and it went all right, I called the bank DB. But when I create Linked server in SQL Management Studio 2008,…
-
1
votes1
answer64
viewsConsult results using SQL or tips on programming in XAILER
I have the following relation between 3 tables: 'SELECT contareceber.codcontareceber, contareceber.codorganizacao, contareceber.dtdocumento, contareceber.dtvencimento, contareceber.valortotalbruto,…
-
1
votes1
answer2021
viewsPHP Connection to FIREBIRD Database
I’m trying to make the connection between PHP and the Firebird database, but I’ve tried several alternatives and I can’t solve them. The error message that appears when trying to make the connection…
-
1
votes1
answer846
viewsSelect in Firebird with PHP using conditions
How do I correctly include select below in php code? I’m having a hard time doing WHERE. SELECT ESTOQUES.produto, ESTOQUES.cor, ESTOQUES.tamanho, ESTOQUES.filial, CODIGO_BARRAS.barra, ESTOQUES.saldo…
-
1
votes1
answer105
viewsReturn code from data entered just after INSERT
i know with java to do, but I did not find anything to do this in Delphi(if possible), whenever and register a new item I search the code by SELECT MAX('FIELD'), but I wonder if it is possible to…
-
1
votes2
answers534
viewsView data in PHP table
I am making a sales report and need to organize the data coming from a bank in Firebird make a report on PHP, however I am not getting know how many data are coming from the bank. Because the…
-
1
votes1
answer55
viewsTwo tables returning only one result
select cliente.codcliente, cliente.dt_cadastro from cliente where cliente.codcliente in ('00000224', '00000170', '00061825', '01009838') order by cliente.codcliente select nfsaidc.codcliente,…
-
1
votes1
answer182
views -
1
votes1
answer1060
viewsDOUBT ABOUT SUBSELECT IN FIREBIRD
Hello, good evening! I have a table that involves the input and output part of a box, an example of this is: no day 01/01/2018 the user reported that entered R $ 200,00 in the company’s vault, the…
-
1
votes1
answer51
viewsCan anyone help with this message here Failed to locate or load the Registered . Net Framework Data Provider?
I created an application with Windows Forms connecting to Firebird, where on my development machine everything works perfectly, but when I put in client machine, the following error occurs:…
-
1
votes0
answers134
viewsProblem with Firebird database path
When I have a way for ex: C:\Programa\bd.fdb and try to pass to the system, windows does not recognize the bank. Now when I have a path as follows: 192.168.1.1\C:\Programa\bd.fdb the database is…
-
1
votes1
answer1020
viewsGroup sum by month and year
I have a simple table in a FIREBIRD database: idCliente: integer dataPagamento: date valor: numeric How to make a select that adds up all amounts payable, grouping by month and year? kind of: select…
-
1
votes1
answer501
viewsUse in select percentage in Firebird
I have the following instruction in Excel: (100%-2%)*2135,68 I want to make an sql: Select (100%-2%)*T.valor as TOTAL from tb_teste T In Firebird I can’t work with %. How can I get around this?…
-
1
votes1
answer119
viewsProblem in FK name size
I have a WebApi to work with a Firebird 2.5, I used the EF at the time, but today I am presenting the following error "The name 'FK_ARRUMACAO_CHECKLIST_ARRUMACAO_ARRUMACAO_ID' is longer than…
c# entity-framework entity-framework-6 firebirdasked 6 years, 2 months ago Lucas Riechelmann Ramos 521 -
1
votes1
answer45
viewsSql using left Join
I have the following tables: TB_ESTOQUE |PRODUTO|QT_DISPONIVEL|COD_FILIAL| |0856322| 5 | 41 | |0856351| 2 | 41 | |0856322| 9 | 114 | |0856720| 3 | 20 | TB_FILIAL |COD_FILIAL|COD_LOCALADM| | 41 | 114…
-
1
votes1
answer122
viewsHow to change the Datatime format in C#?
I get a string with the date, put that string in a DateTime, and put this DateTime in a bank variable. The problem is that the database variable uses a different format than DateTime (Mmddyyyy), and…
-
1
votes1
answer2383
viewsError connecting Firebird database to Nodejs
I’m trying to connect to a Firebird test bench with Nodejs, and I’m using the package node-firebird, and I’m having the following mistake: node index.js Error: Connection is closed. at…
-
1
votes1
answer1636
viewsFirebird - Recover Database
I am trying to recover a corrupted database using Firebird’s own utilities. When logging in to the bank you have the following error: database file appears Corrupt () bad checksum checksum error on…
-
1
votes1
answer661
viewssave in txt the result of the sql query in Firebird using Delphi
I need to save the result of a query inside the txt file by separating by a delimiter, I am extremely new to Delphi and Firebird, so any help is welcome code below: procedure…
-
1
votes1
answer90
viewsPHP - Bring result with select decimals in the Firebird database
How to bring the decimals (.00) back from my array after the database query using PHP? See the result of the consultation; array(2) { ["COD_PRODUTO"]=>string(9) "AM0038784"…
-
1
votes2
answers43
viewsSearch for missing records within the same table
I have a table containing user information. it contains a field called competence. And when I want to pull information from some user I pull competence so: SELECT * FROM registro WHERE competencia =…
-
1
votes0
answers262
viewsDeclare and reference a variable in Firebird SQL Editor Context
it is possible to declare and reference a variable in the context of SQL Editor? I know how to do it in Mysql. For example, follow a Mysql example of what I want. SET @var = 10; SELECT @var; Thanks…
-
1
votes1
answer1923
viewsHow to connect to Firebird database in Python?
I’m making an application myself Python that should connect to a bank Firebird. The application is running on a Linux and the bank in a Windows. My test file worked properly on the server Windows,…
-
1
votes0
answers46
viewsPerformance Firebird
I’m trying to make Firebird faster to enter records via Procedure, but I’m not getting it, currently I see that Firebird does not use 100% of the machine’s available resources, I’ve already searched…
-
1
votes1
answer329
viewsI cannot get result from my updated object list
I am developing the back of a web service and will be my first application in Nodejs v11. Do not notice the lack of separation of 'business rules' with 'bank manipulation' because I am having…
-
1
votes1
answer172
viewsSummarize fields with direct calculations in sql query
I don’t know how to do it I’ve tried almost all day and I can’t if any can help... The problem is I have to add a field that is sine calculated in the direct sql query. Sql: SELECT…