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
votes2
answers167
viewsWith SQL query adding extra column that does not exist in table
You can see that the countryside ORCAMENTO.DATA_VENDA, is duplicated isn’t it? Well, I don’t know how to make it more precise than the field ORCAMENTO.DATA_VENDA, come as null(As if I deleted the…
firebirdasked 4 years, 10 months ago Edu Mendonça 2,564 -
1
votes1
answer49
viewsHow to write all columns of an SQL table + php
Good afternoon, I’m having a doubt, I wanted to create an echo that showed all columns with a select, my code is as follows <?php $db = 'localhost:F:\Dados\TGA.FDB'; $username = 'SYSDBA';…
-
1
votes1
answer189
viewsConstruction CASE Firebird
I need to build a structure CASE in the SQL Firebird only you’re not accepting the way I’m doing. SELECT CONTAS_RECEBER.ID, CONTAS_RECEBER.DT_VENC, CONTAS_RECEBER.TIPO_OPERACAO,…
-
1
votes0
answers84
viewsMultiple Joins to add different values of the same column
I’m having problems in a query (Firebird) with several Selects for the same Stored Procedure (SP_PRODUTO_MOVIMENTO), with practically the same parameters, differing only in the values of a column…
-
1
votes1
answer58
viewsSQL does not calculate with NULL values
I have a query where I have 3 columns grouped and last totaling 3, the problem is for Edson the query is not TOTALING. TOTAL = CREDIT - (DISCOUNT + REBATES) The total Edson has to give 266,49 but my…
-
0
votes2
answers460
viewsExtract Firebird Database with Predefined Layout
I need to extract some information from the database, with a predefined layout and launch into a file. TXT Example: 1 to 10 digit size code; name size from 1 to 20 digits; date sale size of…
-
0
votes1
answer298
viewsFirebird Embarcado
I made an application I want to use the embedded Firebird, I follow all the steps of tips on the net, but on my machine works but when I send to another computer can not find the DLL. I followed in…
-
0
votes1
answer251
viewsProblem with Django authentication
I’m having trouble validating the login, I’m using a legacy bank Firebird 2.5. Could someone help me?…
-
0
votes1
answer134
viewsI cannot load Firebird data into Delphi XE2 using Tzquery
I have a Tzquery created, and I try to load the fields SEQ_CTE and SERIE_CTE according to the code below: ZQuery1.sql.text := 'select * from C000004 where filial = '' + frmprincipal.spanel1.caption…
-
0
votes1
answer697
viewsDjango Legacy Database Authentication
I am developing a project with a legacy database (Firebird), and I was able to configure Settings.py and it is working with the database. When creating a login using Forms, I am not able to create…
-
0
votes2
answers9765
viewsHow can I use the UPDATE command between two tables?
I’m trying to update the field GRUPO table ESTOQUE value 1 (one) when the field NCM table EST_ADICIONAIS is equal to 21011000. Since, both tables have the field CODIGO with equal values. Use…
-
0
votes0
answers324
viewsIs there any way to encrypt the Firebird Embedded database?
I intend to use the Embedded version of Firebird on my application server. Is there any way to encrypt and use this database as in Sqlite?
-
0
votes1
answer825
viewsMirror Bank Firebird
Guys I’m looking for a solution to perform database mirroring Firebird, I’ve heard of a tool called shadow for linux, but I’m looking for a tool that works with windows server.
-
0
votes2
answers12708
viewsConcatenate String in Firebird
How to concatenate String in Firebird? I’m trying like this: select ("00"||"01") AS TESTE from tabela I’ve tried parentheses, no parentheses, column name, no column name... it just won’t... is…
-
0
votes0
answers680
viewsFirebird C# create a single connection to the database
I need to create in my application only a connection using the fbconnection that will be shared across the application. I performed this procedure as follows. I created a static class that provides…
-
0
votes0
answers50
viewsRegistration is not updated in the database
I have an application that takes the content of a given site and compares if it is different from the current one comparing to the record in the database and sends an email that had a change, in…
-
0
votes0
answers408
viewsSetting up Firebird with PHP?
I’m using XAMPP/LAMPP with Centos and I’m trying to configure PHP to connect to a Firebird database. At php.ini I’ve cracked the line extension="interbase.so" and copied the interbase.so to the…
-
0
votes0
answers104
viewsFirebird Database with problems
I have a new Firebird Database, deployed less than 60 days, until then little used, in one day its size was 40 Megas, in less than 6 hours happens users complaint about slowness in the system, when…
-
0
votes0
answers89
viewsFirebird ADO.NET
I updated the "Firebird ADO.NET Data Provider" to version 4.10.0 and am sometimes receiving the following exception in my application. Exception information: Exception type: NullReferenceException…
-
0
votes1
answer223
viewsHow to create this process
I have these two tables in the bank cadcha (Cadastro de chamadas) cadram (Cadastro de ramal) All calls made in a particular company will be saved in this table cadcha. The destination extension…
-
0
votes1
answer505
viewsFirebird execute statement within an exists
I would like to know how to pass the table name as parameter create or alter procedure TESTE ( TABLENAME varchar(30), STATUS varchar(1)) returns ( INCREMENT integer) as declare variable RESULT…
firebirdasked 8 years, 10 months ago Aparecido Silva 113 -
0
votes0
answers278
viewsHow to recompile all Views, procedures and triggers in Firebird?
I need to recompile all Views, procedures and triggers in Firebird, not by Ibexpert, but by Delphi XE2, I will pass an SQL, I would like to know how to perform such a procedure.
-
0
votes1
answer221
viewsFirebird - Parameterized view
Hello. I need to create a View where I will use a parameter whose value will be provided at runtime (Delphi). Could someone give me an example? Grateful.
-
0
votes3
answers710
viewsSorting using Dbgrid with Clientdataset
I’m using a Dbgrid along with a Datasource. And I’m willing to do the ordering as the client clicks on the title. I made the following settings: On my Dbgrid on the Datasource property I inked my…
-
0
votes1
answer834
viewsCreation of Trigger for INSERT in another table in Ibexpert
Good morning, I had the need to create a stock control but I had never used Rigger. I have 3 tables COMPRA ABASTECIMENTO and MOVIMENTO_ESTOQUE Table MOVIMENTO_ESTOQUE : I would like when I make a…
-
0
votes0
answers167
viewsFirebird error with Entity Framework and C#
I’m trying to use Firebird with Entity Framework in C#, but when I create relationships and try to give Update-Database in Migration gives this error: Type is not resolved for member…
-
0
votes2
answers761
viewsFirebird - Select to join two or more lines
I have a table with the following structure: Cliente_id | credito | debito | pedido 1 100 1 1 150 1 1 30 1 2 200 2 2 180 2 How to make a Select that the result is similar to the below? Cliente_id |…
-
0
votes2
answers1080
viewsDoubts in the web service
personal found the following webservice tutorial: https://www.youtube.com/watch?v=0J87qN3B-dI seeing the tutorial I was a little confused about. 1- the web service must be made the part of the…
-
0
votes2
answers565
viewsFirebird Select Query using same field twice
I have a field called patiente_id, I want to create a select +- like this select count(paciente_id where = 0), count(paciente_id where <> 0) from agenda I don’t know it was clear, but I want…
-
0
votes2
answers1059
viewsDatabase error Missing Driver Name Property
I am making a system in Delphi 2010 with Firebird 2.5 that I select a database and I need to pass path location to my Database in my Sqlconnection. procedure…
-
0
votes1
answer119
viewsIt is possible to generate a file . CSV from a table of a Firebird database
I need to generate a file .CSV from a table in my Firebird database, there is some known tool that could help me?
-
0
votes0
answers40
viewsImage reduction in Firebird
I have a Firebird database with some high-definition saved images, someone knows a method to reduce the images without taking them from the bank?
-
0
votes0
answers228
viewsWhy is the timestamp field in the Firebird database displayed differently in a Ruby on Rails application?
I have a database Firebird 2.5 legacy. Access it via IBExpert 2016.9.4.1 This database is part of a request management system that is being migrated from an application Delphi 10.1 Update 2 for an…
-
0
votes1
answer2205
viewsSelect using Join with Distinct
I have two tables: tb_movement | cod | dt_producao | qt_prod | |-----|--------------|---------| | 1 | '04.08.2016' | 10 | | 2 | '04.08.2016' | 5 | | 3 | '09.08.2016' | 12 | | 4 | '10.08.2016' | 3 |…
-
0
votes3
answers406
viewsInsert decimal variable in Firebird
I am making an Insert in Firebird database in a Value field (decimal), but no decimals appear in the table. Code in C# : public decimal ValorUnitario { get; set; } produto.ValorUnitario =…
-
0
votes1
answer122
viewsHow to use Linq2db.Firebird?
lowered the Linq2db.Firebird using the following code: Install-Package linq2db.Firebird The installation was performed successfully, but I am not able to find in Visual Studio, nothing related to…
-
0
votes0
answers157
viewsWhen I give select in any table of my FIREBIRD bank , I can’t "decipher" the varchar
So, I’m having trouble with this bank, I try to give a select . in any table I give select the varchar look like this as you can see . I already changed the charset for everything wants way and…
-
0
votes1
answer221
viewsError passing script from Firebird database to Postgresql
I’m trying to pass a script for creating and inserting data from a Firebird database to Postgresql, but in some tables there is a syntax error, I am using the SQL Manager Interbase & Firebird…
-
0
votes0
answers96
viewsDouble Precision Firebird on PDO
Good afternoon, I am making a query in a table of Firebird using PDO PHP, and in a specific field of this table is returning all the same values in all records, this field is of type Double…
-
0
votes1
answer1334
viewsHow to recover last record inserted in Firebird database?
My Sale table has a Code field with auto-increment and need to recover this code to insert in an associative table. string sql = $"INSERT INTO…
-
0
votes1
answer259
viewsReceive Firebird Exception message in PHP
My script PHP is not receiving the message from exceptions which are generated by Firebird. I have a class that connects to BD, runs sql and disconnects. Debugging the script, I saw that the…
-
0
votes0
answers506
viewsInterbase (Firebird) with Wampserver
I can’t get the php_interbase on my WAMP server, I decrypted the php.ini and yet PHP did not recognize. Man Wamp is 64x 2.5 with PHP 5.5, usage Windows 64 bits. I installed the Firebird on my…
-
0
votes2
answers374
viewsQuery bringing duplicate items + product code
Hi, I’m performing an SQL query on my Firebird server. I made the query using the following syntax: select ds_produto_servico, count(ds_produto_servico) from tb_produto_servico group by…
-
0
votes1
answer297
viewsFirebird + Entityframework with Visual Studio 2015
Hello, I need to create a Firebird connection with visual studio, but I’m having problems with the integration, I searched videos on the internet, and only have reference 2012, I did not find…
firebirdasked 7 years, 9 months ago Victor Hugo 5 -
0
votes0
answers96
viewsDoubt Select / PHP
I’m making a select in this way. $stmt = $lokos->prepare("select CODIGO_PROGRAMA, VERSAO_PROGRAMA, DATA_INSERCAO, DESCRICAO_ALTERACAO from programas_padrao Order by DESCRICAO_ALTERACAO DESC");…
-
0
votes1
answer348
viewsUsing Case in Order By with Union
I’m having trouble using Order by com Case on Union, so it works: select tb_a.nr_rua, tb_a.cod_altura, tb_a.cod_posicao, tb_a.cod_lado where ...... union all select tb_b.nr_rua, tb_b.cod_altura,…
-
0
votes0
answers74
viewsHow to relate these tables, returning specific values?
[Firebird] sgbd - Ibexpert I need to know how to relate these two tables (comment below), so that I get the following results: TABLE:CONTARECEBER DTDOCUMENTO (date entered the system) MATURITY (date…
-
0
votes2
answers621
viewsGroup [group by] SQL Firebird
I wonder if there is a way I can make a query where I can bring fields that are not in my group by. I have the following code: select sum(TAB_FATURAMENTO.vl_item),CLIENTE.insc_cnpj from…
-
0
votes1
answer730
viewsSelect connecting 3 tables in Firebird with different Ids
Good afternoon, I need to make a select that returns to description of the product,barcode and price. The description and price are in one table (TB_ESTOQUE) and the barcode is in another…
-
0
votes1
answer270
viewsProblem connecting to Firebird database
Guys, I’m with a project to do a report that does a search on a Firebird database and I have the file . FB ready to create the bank. However, in connection with dbschema it presents me this driver…