Questions tagged as 'firebird'

Tagged questions
2
answers

SQL Insert with line break

With this SQL command I enter some data in the table, the problem is, in the system the field "ROUTES_PROCESSUAIS.OBSERVACAO" is with line breaks and at save time via SQL the line break is lost. Would you like to make this SQL insert...
asked by 26.04.2018 / 15:20
1
answer

How to validate DBGrid fields before saving?

I have DBGrid , but I want it to validate the fields before saving to the database. I think I have to use the BeforePost event, but I have no idea how to do it. Could someone give me a tip?     
asked by 16.03.2015 / 04:44
1
answer

Using the SQL Firebird case statement

I'm trying to do the following sql in firebird. select distinct tb_proostarefas.*, (case WHEN (tb_proostarefas.dt_prev is null and tb_proostarefas.dt_vencimento < date) then 1 When (tb_proostarefas.dt_prev is not null and tb_proosta...
asked by 16.08.2017 / 13:12
2
answers

Java + Firebird connection returning Null

My connection string with the firebird database returns null. Below is code: public class ModuloConexao { public static Connection conector(){ //criação da varáivel conexao Connection conexao = null; //chamada...
asked by 18.05.2017 / 22:09
1
answer

Create select with multiple fields

How to create a select that makes the relation of at least 03 tables and present a field of each table at least?     
asked by 21.06.2016 / 01:14
2
answers

How to bring the conditions entered as parameters into the SELECT result?

Is there any way to get the parameter values used in the SELECT clause in the WHERE result? Example: SELECT a.*, cast(:dataIni as date) AS inidate , cast(:dataFin as date) AS inidate FROM mytable a WHERE a.date BE...
asked by 02.08.2014 / 19:03
1
answer

How to import firebird data into mysql?

How to import data from Firebird to Mysql using PHP ?     
asked by 18.06.2014 / 13:44
1
answer

Connect with PostGreSQL

I have a *.ini file that connects to my Firebird database, however I need this file now to be configured to connect to PostGreSQL [IBConnection] DriverName=Interbase Database=192.168.1.30:C:\testes\impressoes.fdb Role...
asked by 07.10.2016 / 20:43
1
answer

Error trying to open * .FDB file in IBExpert

I need to open a * .FDB file by IBExpert, until recently I was able to open it normally but yesterday it started to give this error: Home I already checked the control panel and BD Firebird is running fine and I ran the test Telnet...
asked by 18.10.2016 / 12:13
2
answers

Why put COMMIT at the end of the script using the Firebird database

Why in the Firebird database everything I do, including create tables, is necessary at the end of the script to give a command COMMIT ?     
asked by 28.09.2016 / 02:44