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
-
3
votes2
answers304
viewsCreatedatabase Delphi VCL
How to create the database automatically if it does not exist, same in app from Delphi Android, but I want to do it with Delphi VCL. I want my application in the first run to automatically create…
-
3
votes1
answer109
viewsMigrating from Firebird to Mysql
I’m migrating a project in Firebird to Mysql, I’m with a difficulty in converting a trial, would like any hint in how to proceed, below goes the Trial in FIREBIRD. CREATE PROCEDURE…
-
3
votes2
answers385
viewsSQL using sum
I have the following structure: | Data |Quantidade|QTCxVer|QTCxBra| |04.09.18| 10 | 1 | | |04.09.18| 30 | | 3 | |04.09.18| 40 | | 4 | |04.09.18| 50 | 5 | | |05.09.18| 20 | 2 | | |05.09.18| 10 | | 1…
-
3
votes2
answers2038
viewsSQL Insert with line break
With this command SQL enter some data in the table, the problem is, in the system the field "ANDAMENTOS_PROCESSUAIS.OBSERVATION" is with line breaking and at the time of saving via SQL the line…
-
3
votes2
answers727
viewsReduce Firebird memory consumption when closing Dataset
I have an app Delphi XE7 which rotates on a seat Firebird 2.5. When I open a FDTable with a 10,000 records for example, Firebird server memory consumption increases by about 1 MB. So far so good,…
-
3
votes2
answers2934
viewsUpdate using values contained in another table
How can I update a table by setting the value of a field with the same value contained in another table for all records? I have a 'product' table and a 'movproduto' table. I want to update the…
-
3
votes0
answers445
viewsConnect Firebird via PHP
I have a BD in Firebird on a server other than the web server (PHP). I’m trying to make the connection between them, using the ibase_connect function, but nothing happens, my line in php is:…
-
3
votes2
answers490
viewsUsing case in null field
I have the following structure tb_boletim: |Cod|boletim|dt_enviado| | 1 | N | NULL | | 2 | S |24/08/2018| | 3 | S | NULL | | 4 | S |23/08/2018| | 5 | S |23/08/2018| | 6 | S | NULL | | 7 | N | NULL |…
-
3
votes3
answers97
viewsRelationship between the tables
I have the following tables: TB_ESTOQUE |COD_PRODUTO|QT_DISPONIVEL|COD_FILIAL| | 0856322 | 5 | 41 | | 0856351 | 2 | 41 | | 0856322 | 9 | 114 | | 0856720 | 3 | 20 | | 0856322 | 8 | 128 | | 0856322 |…
-
3
votes2
answers642
viewsWhat is SQL dialect 1 and dialect 3?
I don’t understand very well with these database deals but it made me curious these SQL dialect. What SQL dialect? What is the difference between SQL dialect 1 and SQL dialect 3? And what’s the…
-
3
votes2
answers251
viewsFdquery what risks to use variable instead of Parameter
I’m making a connection to search for data inside the bank on one condition IN(), but I had trouble implementing it between FDQuery and the Firebird. Analyzing the problem I realized that command…
-
3
votes1
answer123
viewsSearch for products with more than one word Delphi
I am developing an application and would like to know how to research a product for more than one part of the name, for example: Product: DDR3 8Gb Notebook Ram Memory I would like to do the search…
-
3
votes1
answer2143
viewsUpdate - Firebird with Inner Join
I need to perform an Update on multiple records at the same time, I’m trying to optimize the process! SELECT tei.id_identificador, tes.uni_medida, tep.qtd_atual FROM tb_estoque tes INNER JOIN…
-
3
votes1
answer555
viewsProblems with Python3 in connection with Firebird2.5
I made this Python code (basic connection with Firebird): import fdb con = fdb.connect( host='192.168.1.17', database='/home/firebird/questor.fdb', user='sysdba', password='masterkey' ) cur =…
-
2
votes2
answers3056
viewsError connecting to Firebird 2.5 (64 bit) on Delphi XE3
I have the following error when connecting to Firebird 2.5 (64 bit) on Delphi XE3: DBX Error: Driver could not be properly initialized. Client library may be Missing, not installed properly, of the…
-
2
votes4
answers1944
viewsRun query that concatenates parameters (@p) in Firebird
I need to run a query where the value to be concatenated must be passed as a parameter for the query. SELECT t.id || @p || t.nome FROM Test t; But when executing this query it returns the following…
-
2
votes1
answer1384
viewsDelphi XE7/XE8 - Refresh in database (real-time update)
I have two interconnected systems, one saves a record in the database and another reads the saved record, currently I use a timer to refresh the database in the system it reads, so it takes every 5…
-
2
votes1
answer37
viewsUse of Firebird database from one PC to another
I backed up a Firebird database from a PC and what happens is that I put this database on another PC but then the application says that the database is unique to another user or the program should…
-
2
votes1
answer1139
viewsFirebird - function for decimals and thousands
Is there any native function of the Firebird that returns me the same currency format as the Brazilian or some stored Procedure do this job. Example: #.###,## The point would be the thousand houses,…
-
2
votes1
answer1229
viewsEmbedded database with C#
I’m developing a local app for desktop. As there will be no database servers, I studied some, such as Firebird, Sqlite, Access and even Localdb. But I still feel "lost" in which to work. I know the…
-
2
votes1
answer1600
viewsConcatenate columns and some with NULL value
I’m making a select and concatenating the columns, when a column has value NULL (has no value ) the whole line is NULL follows an example: select…
-
2
votes2
answers7137
viewsError in registering a Firebird 2.0 bank in Ibexpert
I’m having a hard time registering a Firebird 2.0 database on Ibexpert. I appreciate the help! The following mistakes are happening: Attempt 01 Attempting to connect to:…
-
2
votes1
answer562
viewsSetting up an SQL for School Report?
I am trying to mount an SQL to display the results of a School Report Card. In the table of notes I have the data as follows. Table Notes MATERIA | NOTA | PERIODO PORTUGUES | 5.0 | 1Bim PORTUGUES |…
-
2
votes3
answers7592
viewsError: "Connection Rejected by remote interface" using Firebird 3 in . Net
I have an application in Asp.net, which currently uses Firebird 2.5.1 and works normally. I’m testing the 3.0 Release Candidate for soon migrate the version, but does not open the connection, occurs…
-
2
votes1
answer20445
viewsHow to open a. fdb file?
I need to open a database file (.fdb), but I don’t know how. What should I do to open this file? In it there is a list I want to pass to Excel.
-
2
votes1
answer1377
viewsColumn for saving SQL Server change date and time
I’m migrating a database of Firebird for Sql Server and today, in the Firebird I have some triggers on Before Insert/Update who record the TimeStamp the insertion/change and the logged in user. Is…
-
2
votes3
answers3504
viewsHow to remove the last character from a field in Firebird SQL
I have a field in a table that should only contain 4 characters, I realized that the same is with 5 characters and the last is the number zero. Example: Código Errado: 45380 Código Correto = 4538…
-
2
votes2
answers676
viewsQuery does not sort records by Asc/Desc
I have a table called cadcha (registration of call) in the database where all calls made by employees of a particular company are stored. cadcha --------------------------------------------------…
-
2
votes2
answers193
viewsDriver of the Firebird
I am trying to create a webservice with Firebird. I made the codes based on a Mysql video class and I was trying to change to work on Firebird. But obviously it didn’t work. Let’s go to the codes:…
-
2
votes1
answer1170
views"arithmetic Exception, Numeric overflow, or string truncation string right truncation" in search using LINQ
I have a table in a Firebird database CREATE TABLE CIDADE ( CID_CD SMALLINT NOT NULL, CID_DS CHAR(20) NOT NULL, CID_UF CHAR(2) NOT NULL, CID_DISTANCIA_SEDE SMALLINT NOT NULL, CID_CD_ALTERNATIVO…
-
2
votes2
answers362
viewsmodel and controller in codeigniter for making Insert in Firebird using Generator
I am new to codeigniter and need to define my controller and model, so when calling the model inserir(), the controller takes the last Generator ID of each table you want to do Insert. I’ll give you…
-
2
votes2
answers729
viewsHow to view data in a dbgrid
I’m using SQLConnection, SQLDataSet, ClientDataSet, DataSetProvider, ClientDataSet and a DataSource. I need to display the data on one dbgrid, but I’m not sure how to do that. In the FormCreate I…
-
2
votes1
answer91
viewsGenerator x Sequence in Firebird
When to use Generator and how much to use Sequence in Firebird? What difference between the two? There is a difference in performance?
-
2
votes1
answer308
viewsHow to identify the Firebird Server Operating System via SQL?
In postgresql we have the table version where all the data I need will be in it. Ex.: SQL: Select * from version() Upshot: PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux)…
firebirdasked 8 years ago Victor Tadashi 1,219 -
2
votes1
answer383
viewsDelphi - Join two different database tables
I have a Firebird (F) database with professional data: Nome, Idade, CBO I have a Paradox table (P) with occupation data: CBO, Descrição What I want to do is unite these two tables in a way that…
-
2
votes2
answers1580
viewsProblems with charset in the Laravel
I have a database Firebird which was not built through migrations in the Laravel, and it has encoding ISO-8859-1 and I need to return an object in the format JSON for my application, however, in…
-
2
votes3
answers722
viewsCount in Firebird 3.0 Bigint X Firebird 2.5 Integer
In my system, after the migration of Firebird 2.5 to the 3.0, many reports and other functions began to give problem stating that the expected was Integer and the current is LargeInt. I took a look…
-
2
votes2
answers2673
viewsRemove tab(tab) from sweeping
Good afternoon, you guys! I’m trying in every way, but I can’t get a tab at the end of a varchar in Firebird. Someone knows how to do? From now on, thank you. Editing to get more specific: Ex.:…
-
2
votes2
answers1314
viewsConnection limit
System in Delphi - Database Firebird 2.5. I have a server with 25 "files" of databases, one from each client. Each customer has on average 10 accesses via TS to connect to our server. However, when…
-
2
votes1
answer3604
viewsHow to get only time of timestamp?
I have a column timestamp on my table and I need to get only the time of these values. Example of how you are registered: 30.12.1899 17:03 Example of how I need to display through select: 17:00 I…
-
2
votes0
answers582
viewsDisplay a blob image in JS
I need to display images that are saved in the database (Firebird) in Blob and I’m not able to go through with this. is returned a BD Function this Function is read according to the function below.…
-
2
votes1
answer565
viewsDisplay BLOB text
I have the following problem, in a report I need to display a field of the request that is as BLOB. And when I run the search it returns a strange code instead of the field information. $sql =…
-
2
votes1
answer554
viewsQuery returning duplicate values
people I posted here on topic SQL query with duplicate items I just have another question... have a sql: SELECT TABNOV.CODIGO_ANDAMENTO, TABNOV.NUMERO_PROCESSO, TABNOV.INSTANCIA,…
-
2
votes2
answers398
viewsExclusive access to a Chart in Firebird Got How?
Would Open a Table in Mode Exclusive in the Firebird for Delphi preventing other users from opening the Table? I use Delphi 10.1 and Firedac for connection to the database.…
-
2
votes2
answers1468
viewsHow to use Firebird WITH LOCK with Delphi Firedac
I’m trying to Block a table on my system in order to prevent other users from entering the system when the procedure is running, how can I do this using the "WITH LOCK" with the "Firedac"? This…
-
2
votes1
answer248
viewsFetch ip via sql
Does anyone know if there is a way for me to search via sql (Firebird) all ips that are using a Table or Views? I am trying to update a view, but am trying the following error: This operation is not…
-
2
votes2
answers2109
viewsUpdate with the SET of another table
I’m trying to update with JOIN... The following instruction was just a kick to get the idea of what I want to do: UPDATE PCPSEQPROC_001 PCPSEQPROC SET PCPSEQPROC.ID_PCPSEQPROC = PCPSEQ.ID_PCPSEQ…
-
2
votes1
answer213
viewsPerformance with Exists
A colleague mentioned that by making a EXISTS in SQL, it is recommended to use DISTINCT 1 to improve performance. For example, instead of doing: SELECT * FROM CLIENTES WHERE NOT EXISTS (SELECT…
-
2
votes2
answers786
viewsHigh demand stock control with Firebird and/or mongodb
I’m thinking of migrating my ERP (currently in java) from a relational database (currently in Firebird) to a Nosql (probably Mongodb). I am planning and trying to anticipate the possible problems.…
-
2
votes1
answer1114
viewsSaving formatted text in the Firebird database
I know you have a similar question to that, but it’s for tag C# Has with Save formatted text in a TRichEdit in the Firebird? What would be the data type of field that makes this recording possible?…
delphi firebird delphi-berlin delphi-tokyo delphi-seatleasked 6 years, 6 months ago Edu Mendonça 2,564