Questions tagged as 'firebird'

Tagged questions
2
answers

Connection limit

System in Delphi - Firebird database 2.5. I have a server with 25 "files" of databases, one of each client. Each client has in average 10 accesses via TS to connect to our server. However, when the peak time comes close to 4pm, some b...
asked by 02.06.2017 / 22:25
1
answer

Is it possible to synchronize a mysql server with a local Firebird bank?

I'm new to web applications, and I have a MySql DBMS based site. What is the best way to synchronize the web bank with a local bank (where the bank is in a fixed ip)? The local bank is firebird.     
asked by 07.11.2015 / 15:42
1
answer

Firebird - function for decimal places and thousands

There is some native function of Firebird that returns me the currency format similar to Brazilian or some stored procedure that does this service. Example: #. ###, ## The point would be the thousands of houses, millions, etc. The...
asked by 07.07.2015 / 15:15
1
answer

I can not execute a procedure in Firebird

Good afternoon, guys. I need to insert a record in the database but no duplication. I tried this: create procedure My_Proc as begin if(not exists(select * from alunos where nome = 'Mateus')) then insert into Alunos (Matricula, Nome, Idade, O...
asked by 02.01.2019 / 16:16
2
answers

Reduce FireBird memory consumption when closing Dataset

I have a Delphi XE7 application that runs on a FireBird 2.5 . When I open a FDTable with a 10,000 records for example, the memory consumption of the FireBird server increases by
asked by 08.06.2018 / 14:48
2
answers

Error connecting to Firebird 2.5 (64-bit) in Delphi XE3

I'm having the following error connecting to Firebird 2.5 (64 bit) in Delphi XE3:    DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, of the wrong version, or the driver may be missin...
asked by 28.02.2014 / 01:39
2
answers

How to extract blob files in firebird?

I have in a table a field of type BLOB (BLOB SUB_TYPE 0 SEGMENT SIZE 80) where I store some binary files. I need to extract all the files stored in this table. Through IBExpert in the "Data / Form view" tab a field is displayed where I can right...
asked by 16.05.2014 / 20:36
1
answer

How to identify the Firebird Server Operating System via SQL?

In postgresql you have the table version where all the data that I need, will be in it. Ex.: SQL: Select * from version() Result: PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux) 4.8.3 20140627 [gcc...
asked by 21.11.2016 / 20:15
1
answer

Delphi - Merge two tables from different databases

I have a Firebird (F) database with professional data: Nome, Idade, CBO I have a Paradox (P) table with occupancy data: CBO, Descrição What I want to do is merge these two tables so that it stays: Nome, Idade, CBO, Descrição where...
asked by 26.11.2016 / 19:48
3
answers

How to remove the last character of a field in Firebird SQL

I have a field in a table that should only contain 4 characters, I noticed that it is 5 characters and the last one is the number zero. Example: Código Errado: 45380 Código Correto = 4538 Can you delete the last character of a field in F...
asked by 31.03.2016 / 02:30