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
votes1
answer283
viewsView data in Array
I’m doing a query in a database and I need to display the information on the screen, but searching one at a time. I tried to do by array, but it is not displaying the vector. Code: <?php $a =…
-
0
votes1
answer197
viewsAccent code page in Command Prompt
When updating my system application, a command line is called to execute a script to update the database. The script calls the tool Isql of Firebird sending as parameter the file that contains the…
-
0
votes1
answer343
viewsSQL - Delete records that have a field with the same value as another, only when there is more than one record
I have a product bar code table, I want to delete only those bar codes that are the same as the product code and that have another code besides this one. Table: CodProduto CodBarra 01 01 < não…
-
0
votes2
answers95
views -
0
votes1
answer192
viewsSearch multiple PHP items database
I have the following problem in PHP, I’m doing a search in a bank Firebird in order to be able to issue a report with the sales requests. I will enter the order ID one by one and you will return the…
-
0
votes1
answer47
viewsProcedure does not return the full column
I created a project with the ibexpert, does the commit correctly, but at the time of turning the Procedure, get the bug: Multiple Rows in Singleton select. My intention is to list all values in the…
-
0
votes1
answer515
viewsChange column value in Firebird
I have a table with approximately 7 thousand records, I need to create a new column in this table but I would like all old records to have the value’S', when I try to create the column the fields…
-
0
votes1
answer718
viewsMask CNPJ in Firebird
I need to mask my CPF field / CNPJ direct on Firebird, I tried the command below but it shows error, can anyone help me? UPDATE EMPRESA SET EMP_CPF_CNPJ = SUBSTRING(EMP_CPF_CNPJ from 1 for 2) + '.'…
firebirdasked 6 years, 11 months ago j_ferrareze 1 -
0
votes1
answer573
views"gen_id()" or "select max()" for Auto Increment in a PK field?
Currently I use a Trigger with this SQL code to get an Auto Increment to be assigned in the primary key field (PK) of the tables: create or alter trigger TRI_CLIENTES_BI for CLIENTES active before…
-
0
votes1
answer181
viewsHow to store the returned field value with the "Insert" command in a variable?
I have a Procedure that performs the "Inserts" and "updates" in the tables. The need to create it was to try to centralize all check functions before entering or updating records. Today the need…
-
0
votes1
answer698
viewsHow to improve select performance
I have to use Firebird, but I do not get along very well with database, I selected the following way: select first 5 skip ((1 - 1) * 10) distinct PRO.CODIGO, PRO.NIVEL_INTERESSE, PRO.DATA_RETORNO,…
-
0
votes1
answer28
viewsImage conversion with PHP
It’s my first day with php and I’m doing a select that returns an image, as I do to render this image. Follow my select and the return of the image: class CooperMaisController { public function…
-
0
votes3
answers68
viewsSelect on a date and return cannot be null
I need the return of a date, if it is "Null" in the BD return another date or other data that is not "Null".
-
0
votes1
answer28
viewsWhy were views slow after migrating data via script in Firebird 2.5?
I’m working on a standardized database. I recently refactored her structure (A) by renaming all existing PK and FK, because they had the names that are automatically generated. When migrating data…
-
0
votes1
answer417
viewsTransfer fields from one table to another
Good morning, is there any way to transfer the fields to more than one table? I have an outdated database and need to create the new fields in several tables. Is there any query that does this, use…
-
0
votes2
answers256
viewsFirebird sql error and doubts
I own this table code CREATE TABLE news ( id_news INTEGER NOT NULL, title VARCHAR(128) NOT NULL, slug VARCHAR(128) NOT NULL, text TEXT NOT NULL, PRIMARY KEY (id_news), KEY slug (slug) ); That is…
-
0
votes1
answer1224
viewsHow to run PHP + Firebird on Docker?
I’m trying to run/create a container in Docker with PHP + Firebird, I found a container that runs the Firebird, I found another that runs PHP and Firebird, but when I try to consume the database:…
-
0
votes1
answer50
viewsSQL grouping information
I have the following sql statement: SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR' AND TIPO_CAMPANHA = 5 AND DT_CAMPANHA = '01.08.2018' UNION SELECT * FROM TB_CADPRECO…
-
0
votes2
answers76
viewsHow to use Firebird 2.1 > ABS in Firebird 2.0?
I have a client who already has a system that runs on Firebird 2.0 and my system runs on the newest version of Firebird, with this I had to regress the database and has some functions that 2.0 does…
-
0
votes2
answers98
viewsSelect data from three SQL tables
I am trying to join data from three tables using this sql: SELECT cod_nota, cupom, valor_contrato, valor_cadastro, data_emissao FROM cupons_nota, vendas, notas_fiscais WHERE cupons_nota.cupom =…
-
0
votes1
answer368
viewsCharacter change at - sql position
To replace the third character of a string in Firebird, example: 00028 by 00128, 00029 by 00129... Someone could help me, I tried to see by replace, but I can’t determine the position
-
0
votes1
answer69
viewsFirebird JPA returning null values
When I try to get some record from the bank, some fields come null, although in the table they are not null! Any idea what might be causing this behavior? I’m using Java 8, Hibernate 5.2.4, Jaybird…
-
0
votes0
answers223
viewsView images from a BLOB field of a Firebird database in PHP
I think someone will feel entitled to say that this question is a duplicate, but I disagree, there is a question that answers in a simple and objective way a method of displaying an image of a field…
-
0
votes1
answer36
viewsShow message if IN record does not exist
I want to put several CPF numbers on IN of a query and if the CPF exists in the table show the data, but if it does not exist show a column indicating that it does not exist in the table. Exemplo:…
-
0
votes0
answers552
viewsProblems opening *.FDB file by Ibexpert
Good morning! I’m trying to pull a database from an old system to read the information. I downloaded and installed Ibexpert, but while trying to open the file I get the following error: "Unsupported…
firebirdasked 6 years, 2 months ago Hebert Richard Masseno Dias 291 -
0
votes1
answer160
viewsProblem with full Outer Join filtering with Where
Friends, I have a database with the following tables: guys id | nome 1 | Duplo 2 | Triplo availability data | tipo | ocupado | manutencao | referencia 01/03/2018 | 1 | 1 | 0 | 54684 01/03/2018 | 1 |…
-
0
votes0
answers205
viewsFirebird database connection with golang
Does anyone use Go to access Firebird database? I’m having connection problems and I’m not being able to solve them !! My connection string Conn, err := sql. Open("firebirdsql",…
-
0
votes1
answer143
viewsLeft Join Slow on Firebird 2.0
I have two tables: Sale > 100 Records Primary key fields: Invoice Payments > 200,000 Records Primary key fields: Id, Invoice, Type, Document. I have the following SQL: Select V.FATURA, P.ID…
-
0
votes1
answer398
viewsAccess Firebird Centos7 Database
I normally installed Firebird 3.0.3 in Centos7 - Firebird-3.0.3.32900-0.amd64 [root@localhost firebird]# ps aux |grep firebird firebird 1099 0.0 0.0 29644 1004 ? S 17:22 0:02…
-
0
votes1
answer851
viewsFirebird remote database access error 3.0.3
Trying to connect the database on Centos7 server with Ibexpert I have the message: Unsuccessful Execution caused by a system error that precludes Successful Execution of subsequent statements.…
firebirdasked 6 years, 6 months ago Aparecido Silva 113 -
0
votes1
answer223
viewsDoubt in SQL query with Group by and Order by
Good afternoon Galera!!! I have an sql query that is simple, but I’m having a hard time doing an order by in two fields at once. Such consultation is for me to assemble a report, but before mounting…
-
0
votes1
answer1307
viewsError opening/creating Firebird database
I have a problem with Firebird. I installed Delphi and Firebird, but when I try to open the base it is a mistake. Trying to open by ibexpert gives the following error unsuccessful execution caused…
-
0
votes1
answer197
viewsSearch item result in same line separated by comma
I have a select that returns the risks (work safety) in several lines, I would like the item "T4.RIS_RISCO" to appear in a single line separated by comma, can anyone help me?? have basic…
-
0
votes0
answers81
viewsIntegration between two databases
I have an idea to integrate two databases, at one point I have the database Postgressql with system A and on the other side a bank Firebird in system B. For example: I recorded a client on system A…
-
0
votes1
answer185
viewsUsing Count with select all
I am wanting to make an sql counting the records with duplicity: select produto,matricula,data,fornecedor, count(*) from tb_teste group by produto,matricula order by fornecedor This way of the…
-
0
votes1
answer477
viewsMaster and Detail in Delphi, with Schemaadapter, only recorded the second time onwards
I am using Delphi 10.1, Firebird 2.5 with Firedac. I have 3 Fdquery, all with Cachedupdates = true, being 1 MASTER, and 2 Detail. In the bd, the FK points to the ID of the master table. In the…
-
0
votes1
answer37
viewsAid with update performance
I have the following situation: I have to update some ids with the where in a requisition number, but are between two banks, firebirds, different. I did this: while not qry1.eof do begin…
-
0
votes1
answer147
viewsError Method Update EF Core with Firebird 2.5
When trying to update an entity Firebird is returning me this error "Implementation limit exceeded block size Exceeds implementation Restriction", simply take the entity of the bank and have it…
c# firebird entity-framework-core firebird-2.5asked 6 years, 4 months ago Lucas Riechelmann Ramos 521 -
0
votes1
answer697
viewsHow to perform a search disregarding Firebird special characters in the WHERE Clause
I’m making a View and Clause WHERE it does not accept a filter of this 'Temporary' only if removing the accent Ex: 'Temporario'. CREATE VIEW VWORDEMPRODUCAO ( CODEMPRESA ) AS SELECT F002 AS…
-
0
votes2
answers39
viewsComplete number of query records
Hello! I have a table in BD that can contain from 0 there are 12 records. (as a monthly income chart during the year. totaling 12 records) I want to make a query in this table and I want it to…
-
0
votes1
answer204
viewsConflit FIREBIRD Lock Error
I’m new to the subject of database, so I hope you understand my doubt and lack of knowledge: We use Firebird as SGDB and Ibexpert as a tool for database administration and configuration. Because the…
-
0
votes1
answer148
viewsWhat is the Difference between Select and Run in a Procedure?
There is some difference between making a Select to call the Procedure and giving a Execute in the Procedure, for example, in select a Procedure is in Read-Only mode and in execute no?
-
0
votes1
answer282
viewsGenerate dates between ranges in Firebird
I need to select and return a date range in Firebird. It should be the same logic as generate_series postgresql. SELECT date_trunc('day', dd):: date FROM generate_series( '2019-07-22'::timestamp,…
firebirdasked 5 years, 4 months ago Luiz Roberto Furtuna 593 -
0
votes1
answer91
viewsproblem when running select on more than one table in Delphi and Firebird
select works on Firebird, but error -104 on Delphi IBQuery2.SQL.Add('select l.jb_cdempresa, l.jb_cdfilial, p.dtvencimento, l.jb_cdcontacredito, p.vlrpago,'); IBQuery2.SQL.Add('l.jb_cdcontacredito,…
-
0
votes1
answer116
viewsPHP+FIREBIRD - Bring table relations result
In Ibexpert the query below brings the data that correctly, but when I use the same query in PHP does not work. SELECT FUNCIONARIOS.nome, CNPJ, cod_funcionario, LOGRADOURO, CONTATO, cidade, estado,…
-
0
votes1
answer21
viewsReturn a single line per code
I have a table that keeps a client’s record and its duration in operation. sql needs to return me only the last client term (the most recent one). no code can be repeated follows the result that sql…
-
0
votes2
answers518
viewsFirebird perform automatic reset on Generator
Environment : Linux server running Firebirdcs 2.5 Superclassic ; desktop application Delphi 7 Dbexpress; hundred of machines consuming. Dear friends, In the database there is an order table where…
-
0
votes1
answer51
viewsSet primary keys in sequence
I have the table empresas as an example: cod | nome ----|---------- 3 | Asterix 7 | Lunar 13 | Coimbra Fortunately the table of companies currently has no reference in another table, I would like to…
-
0
votes1
answer282
viewsI want to total the multiplication of two columns
SELECT ID_PRODUTO AS CODIGO, BARRAS AS CODIGO_BARRAS, PRODUTO AS NOME, ESTOQUE AS QUANTIDADE, CUSTO, **(ESTOQUE*CUSTO) AS VALOR_TOTAL -- A TOTALIZAÇÃO É PARA ESSA…
-
0
votes1
answer30
viewsSelect Chained between two tables using criterion the field of the first
Good afternoon, great masters. Here’s the situation, I need to get you out d12400 all field results nrentg in which the field dtentg be = '13.10.2020', to search in the table d12410 the fields that…