Questions tagged as 'firebird'

Tagged questions
1
answer

How to do migrations and versioning with firebird database?

I recently found this site Flyway DB where, as far as I understand, it is possible to create migrations and control the version of the database. But I do not think it supports Firebird. Is there any similar tool with firebird support? Or is it...
asked by 12.08.2015 / 22:24
1
answer

Firebird - transaction monitoring

I updated my Firebird to versão 2.5 and would like to view the transactions, I saw in several links that the command: SELECT * FROM mon$statements resolves, but this command gives me an error:    Undefined name. Dynamic...
asked by 18.05.2015 / 14:23
1
answer

How to allow the insertion of information in the database using DBLookupComboBox?

I have a DBLookupComboBox that captures the data in the Species table so that the user can select what he needs, after which this data is saved in the Animal table. p> My question is how do I get the user to add a new record to D...
asked by 14.03.2015 / 03:42
1
answer

Using GFix in a C # application

I'm developing a C # application and I need to pass GFix to a FireBird database, I thought about running a prompt window and passing the GFix commands to it, but I'm not getting it. Also I need to return a message to the user if the database is...
asked by 25.11.2014 / 19:11
1
answer

Error Running a Firebird Trigger

I have the following Trigger generated in my database: SET TERM ^ ; CREATE OR ALTER TRIGGER ATUALIZA_CODNCM FOR EST_ADICIONAIS ACTIVE BEFORE INSERT OR UPDATE POSITION 0 AS begin UPDATE est_adicionais set id_ncm = (select ncm.id from est_ad...
asked by 04.11.2014 / 17:04
1
answer

Failed to connect database: Connection lost to database - Firebird and Delphi application

I have a server with over sixty client databases that currently operate with Firebird 3.0.3.32900 and an application in Delphi that is responsible for synchronizing logs from one end to the other. To exemplify, the application is responsible for...
asked by 03.12.2018 / 15:50
1
answer

Error opening / creating base in firebird

I have a problem with Firebird. I did the installation of Delphi and Firebird, but when I try to open the base it gives an error. Trying to open by ibexpert gives the following error unsuccessful execution caused by an unavailable resource. un...
asked by 18.10.2018 / 14:41
1
answer

Using SQL in coalesce with Date

I have the following question. In SQL your doing so works. ...and coalesce(tb_cadastro.cod_produto,'') = coalesce(:COD_PRODUTO, coalesce(tb_cadastro.cod_produto,'')) and ... Where COD_PRODUTO is an integer, what would I do if the fie...
asked by 18.10.2018 / 13:29
0
answers

Problem with firebird database path

When I have a path eg: C:\Programa\bd.fdb and try to pass to the system, windows does not recognize the bank. Now when I have a path like this: 192.168.1.1\C:\Programa\bd.fdb The database is recognized normally, and also works for othe...
asked by 04.05.2018 / 20:28
1
answer

DOUBT ON SUBSELECT IN FIREBIRD

Hello, good evening! I have a table that wraps the input and output part of a box, an example of this is: On 01/01/2018 the user informed that he entered $ 200.00 in the company safe, on the same day he made another entry transaction in the amou...
asked by 01.01.2018 / 21:59