Questions tagged as 'firebird'

Tagged questions
2
answers

FDQuery what risks in using variable in place of Parameter

I am making a connection to fetch data inside the bank with a IN() condition, however I had difficulty implementing this between FDQuery and FireBird . Analyzing the problem, I realized that the SQL command was reaching the d...
asked by 08.11.2018 / 02:21
1
answer

Firebird C # singleton pattern

I'm using the following function to connect to the database, I'm programming in C # in Visual Studio 2013. namespace WindowsFormsApplication1 { static class Conexao { private static String strConn = Properties.Settings.Default...
asked by 03.11.2015 / 15:23
2
answers

Query values with 0 included in count () even if they do not have values

I need to check the number of notes issued with template 55 to create a report. The problem is that I'm having to put zero values in the quantity column even though they have no value at all. Ex: empresa filial data quantidade 5...
asked by 13.12.2016 / 12:53
1
answer

Duplicate Registry - Firebird

In Firebird how to delete duplicate records, keeping only one of them? Could you help me. I have this select, however it deletes all logs, I use firebird 2.1 delete from vendaproduto where vendaproduto.pro_codigo in (select ven...
asked by 26.08.2015 / 13:02
1
answer

How can I make a select in PHP with FIREBIRD PDO?

I've already made a correct connection to Firebird using PHP, however I'd like to know how I can do select in a certain bank. Can anyone help me please? <?php $user = "SYSDBA"; $pass = "masterkey"; try{ $lokos=new PDO("firebird:loca...
asked by 01.07.2015 / 20:19
2
answers

Convert the SQL syntax of the Firebird database to Postgres database at runtime

I have a system developed in Delphi 7 already stable using the Firebird database, and some clients have requested that they can use Postgres as a database on that same system. As in some SELECT'S, my system uses some reserved Firebird words,...
asked by 24.11.2015 / 21:08
0
answers

Connect Firebird via PHP

I have a Firebird DB 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: $dbh=ibase_connect($host,$username,$password) or die(i...
asked by 03.08.2018 / 15:46
2
answers

Numeric Overflow with Numeric (18,7) in Firebird

I need a precision of 7 houses in a given split calculation, but when the divisor is too small, it generates an extended number. When I try to cast, it gives numeric overflow, even the number "fitting" in the cast. The sql is as follows: selec...
asked by 11.03.2016 / 16:01
1
answer

Select hibernate + ifrebird

I'm not sure what to do. follows the class and error Advertência: #{mbeanUsuario.Vusuario}: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement javax.faces.FacesException: #{mbeanU...
asked by 22.01.2016 / 14:10
0
answers

How to copy data database firebird fdb to gdb

I have a firebird database in fdb format, it has a table that I want to import into another firebird database in gbd format.   How do I make this process?     
asked by 12.08.2016 / 05:52