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
-
0
votes0
answers124
viewsGet numerical values from the database with comma and dots [FIREBIRD + C#]
Hello, everyone. I’m having trouble retrieving the numerical values from the database in my Datagridview already formatted (including commas and dots). The code that gets the data through a process…
-
0
votes0
answers61
viewsFirebird + Entityframework - Problem to add connection
I’m having trouble adding a Firebird connection to Visual Studio I followed every step of the documentation I installed Firebirdsql.Data.Firebirdclient gacutil / i…
-
0
votes1
answer23
viewsAND no SQL (Firebird)
I have the following code: UPDATE PRODUTOS SET categoria = '001' WHERE marca = '1774' But there are over 400 brands.. I thought about using AND in Where to do it with multiple brands at once, but it…
-
0
votes1
answer189
viewsQuery in SQL/Firebird grouping a sum by nature
I’m trying to make a Query in the product table to return to me the following information below: I’m trying to do it in a grouped way by totaling the values. There is a spine by name nature, that…
-
0
votes1
answer63
viewsWhat are the advantages and disadvantages of using Auto Increment Field in Firebird?
I’ve heard of some people who use Campo auto increment can give complications in the database on account that it can make several jumps in the numbering and even get lost in the counts. I don’t know…
-
0
votes2
answers283
viewsSQL Firebird search for last names by initial letter
Precise research by the letter initial of the surnames within a column that has full and compound names. Examples: Jean Carlos Luciana Menezes Rezende Roberto Menezes Souza Vero Vinicius Desired…
-
0
votes1
answer30
viewsUnexpected end of random command in Firebird
I’m having a problem in the system I develop, for some reason I get the message: Unexpected end of command - line 1, column 214 But I can’t find which SQL the problem is occurring. From what I found…
-
0
votes1
answer1041
viewsProblems creating API with Firebird Database and Node JS
I am studying how to develop an API to query data from a Firebird database. To do this I am using the Node-Firebird, but the connection does not seem to be working. Follows excerpt from the code:…
-
0
votes1
answer122
viewsHELP! How to perform Datediff with difference between columns and not current_date?
I’m in need of a simple, data difference (DIA) feedback on Firebird, but I’m not getting the feedback and try many ways ... the Command below works ... Datediff (day from Max (distinct TRAVEL.DATE)…
firebirdasked 5 years, 2 months ago Victor Andrade 35 -
0
votes1
answer424
viewsConvert Varchar in Int or Int in Varchar (SQL Procedure)
in Procedure there are two fields (Cod_manufacturer(VARCHAR) and Codigo_manufacturer(INT)), a Varchar and an Int, when I do a LEFT JOIN to cross the tables, it gives me a conversion error, I tried…
-
0
votes0
answers97
viewsFirebird backup on C#?
I am backing up a Firebird database on C# but is returning the following error: unrecognized service Parameter block Follow my code below string cmBackup = @"C:\Controle Escolar\Ano_2011\Banco de…
-
0
votes2
answers108
viewsDoubt Python with Firebird database query
Hello I have a problem with the Firebird database query. I make the connection with the bank and step this query, but the problem is in return, it returns the name of the normal product only that…
-
0
votes1
answer363
viewsError connecting to Database - Firebird/Java
I am trying to connect a java desktop application to a Firebird database and the eclipse console shows the following error: "PM org.firebirdsql.logging.Jullogger warn: WARNING: No Connection…
-
0
votes1
answer211
viewsGroup records and create column in SQL Firebird
I have the following records: |MAQUINA|LOTECA| DTPOST |SEXOCAR|QTDEPIN| |17 MAQ |602121|02/04/20|Fêmeas | 9300 | |17 MAQ |602121|02/04/20|Machos | 9600 | |17 MAQ |602121|02/04/20|Fêmeas | 100 | |18…
-
0
votes0
answers33
viewsEdatabaseerror "zqryList: Field 'Number' not found" when the alias contains "/"
There is a field in the SQL of my form with the alias "Number/Minuta", and when the SQL is executed for the second time the message Field 'Number' not found is fired. I can solve this by giving a…
-
0
votes0
answers135
viewsFirebird - Concatenating fields that return from a case
SELECT DP.DATA AS DATA, S.DESCRICAO, COUNT(P.CODIGO) AS QNTD, (CASE WHEN (CAST(SUBSTRING(P.HORAFIM FROM 1 FOR 2) AS INTEGER) = CAST(SUBSTRING(P.HORAINI FROM 1 FOR 2) AS INTEGER)) THEN…
-
0
votes1
answer197
viewsJPA connection to Firebird error
I always used mysql for the database, but now I have a need to connect with a band Firebird(FDB) in a project, I am using Maven, when trying to connect spring returns me the following error: Caused…
-
0
votes0
answers208
viewsPhp 7.3 I am unable to connect to Firebird
Person who can help me I’m already a week cracking my head I bought a system and the bank and Firebird file fdb version 2.5 I want to assemble another program but I need to align the banks, until it…
-
0
votes0
answers53
viewsExclusive connection on Firebird
I am having a problem in production environment, because my application is trying to access exclusive form the database and precise circumvent this problem. In debug this did not happen. Returning…
-
0
votes2
answers64
viewsSelect returning null values in the database
SELECT S.ID_SALES, S.ID_CLIENT, C.FULL_NAME, S.SDATE, coalesce(S.billed, 'N') BILLED, P.product_description product, I.amount, I.unit_cost, I.unit_cost * I.amount SUBTOTAL, coalesce(I.discount, 0)…
-
0
votes1
answer62
viewsHow can I get all data stored in an array
I am programming a system in Delphi that should trigger automatic emails, and to store some of the emails that I have in my database, I place them in an array as follows? function…
-
0
votes1
answer39
viewsError accessing state change that has a country
I have a state register, which has a country. It registers normal, only that error occurs when accessing the state change. I don’t know if it’s right, but from what I understand, something from the…
-
0
votes1
answer88
viewsHow many days a week (Monday, Tuesday...) do you have in a 1-month period?
I need help to return in an SQL the amount you have of each day of the week in a period of 1 month, for example in the month 06/2021 has 4 Mondays,5 Tuesdays,5 Wednesdays...etc. I need to know the…
-
0
votes1
answer33
viewsDoubt column concatenation
The code below returns a sum per classification. Something like this: Services = type 1 Materials = type 2 the expected result is that there is only one row, and that in this Row I have the value of…
-
0
votes0
answers31
viewsHow do I Compare fields from different tables using HAVING
I’m trying to make an SQL query in Firebird where it will only return data if the sum of the fields in the first table is different from the Field "vlrnota" of the second table. However, when trying…
-
0
votes2
answers37
viewsHow can I apply increase and percentage reduction over unit value
The script below calculates the consumption value for materials and medicines , grouping by patient. select coalesce( sum ( ( (L.QTDE) - coalesce( sum( ( select sum(QTDE) from GECADDEV CD inner join…
-
-1
votes1
answer110
viewsBDE does not connect to Sysdba user
I’m going through some problem with my BDE that I don’t know yet right what it is, for some reason it doesn’t connect in the bank with the user|default password of Firebird. I connect the same bank…
-
-1
votes5
answers1444
viewsQuery pass null parameter
I can pass the value is null or is not null through a Query? Example in SQL: select * from tb_teste where tb_teste.data_hora :PARAMETRO; At Delphi: Query.ParamByName('PARAMETRO').value = 'is not…
-
-1
votes1
answer474
viewsView active connections on the Firebird server
I have a Windows Server server and in it we have installed Firebird Server Classic 2.5. How we can verify how many clients we have connected to the Firebird server. Thank you.
firebirdasked 4 years, 7 months ago Lucio Mestrinare 25 -
-1
votes1
answer904
viewsFormat Firebird SQL data dd/mm/yyyy
How to convert a date to dd/mm/yyyy format in Firebird ? I tried some ways to convert 2020/06/22 to format but always come out in YYYY/MM/DD format: CONVERT(DATE, DATA, 103) AS "Data"…
-
-1
votes1
answer81
viewsCOUNT + JOIN WITH DIFFICULTY IN RESULT
I need to get two results... I have a table with a total of 102 drivers and another table with the date he left to make deliveries and another with the arrival date... I need to know which drivers…
-
-1
votes1
answer48
viewsWhy can’t I group data into that query?
SELECT e.idproduto codigo, p.descricaoproduto nome, sum(e.qtde) entrada, sum(s.qtde) saida FROM itementrada e INNER JOIN produto p ON e.idproduto = p.idproduto INNER JOIN itemsaida s ON p.idproduto…
-
-1
votes1
answer302
viewsCalculate duration time - Firebird 2.5
I have the following table: Stages: 0 = Separation, 1 = Packaging, 2 = Conference, 3 = Shipment Status: 0 = Waiting, 1 = Started, 2 = Finished, 3 = Paused And this table is part of this screen: For…
-
-1
votes2
answers193
viewsSQL Compare values in other rows
I have a table called transferencia that has data on the movement of a guest in a hotel, for example The table has no date of departure, so the date of departure is the data_entrada in which the…
-
-1
votes1
answer107
viewsINNER JOIN data mixed in php + json
Good evening, so I’m trying to create a API, and I came across the following problem, I’m not able to group the data from my inner join, follows the code : <?php $json = array(); $db =…
-
-1
votes2
answers174
viewsRun SELECT command in Firebird database with Javascript
Hello, I made a code to execute a select in a database Firebird using javascript, with the library Node-Firebird, the code is this: firebird.attach(options, (err, db) => { if (err) throw err…
-
-1
votes1
answer27
viewsSend files to Mysql in Blob
good morning. Does anyone know how to send exe and csv files to Mysql using Delphi? I didn’t find much in it. I need to save CSV files in the table but when I import by the test below the file size…
-
-1
votes1
answer33
viewsSUBSELECT - POSSIBILITY OF IMPROVEMENT
I would like some guidance on a query. It is working, but the current script generates a very high reading demand in the bank due to a case comparing a table data, with another through a subselect…
-
-1
votes0
answers18
viewsTable relationship modeling in Libreoffice Base
I’m working on a little personal project using Libreoffice Base. The idea is to make a small database to catalog my comic book collection. I am a complete beginner (both in Database and in…
-
-2
votes1
answer84
viewsHow can I correctly use a PDO object for a selection query
i followed the recommendations of php.net, to make a select in a certain database using PDO, however I do not know if I am doing it the right way, I wonder if you can help me $duosig = "SELECT…
-
-2
votes1
answer1447
viewsHow to resolve "Unknown user name or password unavailable database alias" error?
My program is in Delph7, BDE bank, Firebird 2.0, but when access gives the following error: Unknown user name or password unavailable database alias How can I solve this problem?…
-
-2
votes1
answer55
viewshow to group an sql
I have an SQL that when run gives error. Someone could help me to perform the grouping of this SQL? select i.ref, r.nome,n.qtde,sum(n.vlr_tot) from geitens as i inner join gerefer as r on r.cod =…
-
-2
votes1
answer58
viewsFirebird: What to do when a framework uses a reserved word?
I have a problem creating the database when using Adianti with Firebird 2.1, because the words PASSWORD AND ACTIVE are reserved in Firebird and I can’t set them as an attribute. What can I do to…
firebirdasked 4 years, 9 months ago Erikles Bonfim Ribeiro 19 -
-3
votes2
answers380
viewsFirebird - Tools
What tools are most used in Firebird management? I know Ibexpert, but he gets paid. There is something similar to Ibexpert, but free?
-
-3
votes1
answer693
viewsSeveral UPDATES in the Firebird database
I can create a method that performs several updates in the Firebird database? For example, I want to update the following record, but it would have to be one at a time, have to update otherwise?…
-
-3
votes2
answers108
viewsConsultation with grouping
Good morning gentlemen(s) I have the following problem: [Edited] As can be seen in the image above, there are several fields with the same result (minus the "desric" column). What I need is that in…
-
-4
votes2
answers240
viewsCompare a field in the same table
I need to double-check the register with the same CNPJ to eliminate duplicates. select needs to bring the code information,duplicate clients name. Bank structure: tabela CADCLI ( codigo, nome,cnpj )…