Questions tagged as 'firebird'

Tagged questions
2
answers

Select data from three SQL tables

I'm trying to merge data from three tables using this sql: SELECT cod_nota, cupom, valor_contrato, valor_cadastro, data_emissao FROM cupons_nota, vendas, notas_fiscais WHERE cupons_nota.cupom = vendas.numero_nf AND notas_fiscais.cod_cliente='0...
asked by 24.05.2018 / 15:20
0
answers

I am not able to create a firebird connection on an asp page

I'm using the link pages and link as references. While putting the recommended files on the server, testing the connection is experiencing an error. I'vetriedconnectingtothefullstringorjusttheDSN,neithercaseisworking.setstrConexao=Cre...
asked by 06.06.2018 / 17:36
1
answer

Query in SQL query with Group by and Order by

Good afternoon, everyone! I have a sql query that is simple but I'm having a hard time performing an order by two fields at the same time. Such a query is for me to assemble a report, but before assembling I need to validate this query. The q...
asked by 13.05.2018 / 19:27
0
answers

Connection with PHP Firebird

I use a connection to firebird on port 3050, but one of the clients had to change to port 40494 and the ibase_conect () function returns error: -902 - Unable to complete network request to host "ronsani.ddns. com ". Failed to establish a connec...
asked by 10.05.2018 / 13:45
0
answers

connection error localhost php + firebird

I'm having these errors   Warning: ibase_connect (): Unable to complete network request to host "127.0.0.1". Failed to establish a connection. in C: \ xampp \ htdocs \ panda \ php + fb \ connection.php on line 7 Follow the Firebird connec...
asked by 08.05.2018 / 14:41
1
answer

Error accessing remote database Firebird 3.0.3

Trying to connect the bank to the CentOS7 server with Ibexpert I get the message: Unsuccessful execution caused by a system error that includes successful execution of subsequent statements. Install incomplete, please read the Compatibility c...
asked by 03.05.2018 / 17:38
1
answer

Access Firebird CentOS7 Database

I usually installed firebird 3.0.3 on CentOS7 - Firebird-3.0.3.32900-0.amd64 [root@localhost firebird]# ps aux |grep firebird firebird 1099 0.0 0.0 29644 1004 ? S 17:22 0:02 /opt/firebird/bin/fbguard -pidfile /var/run/firebird...
asked by 03.05.2018 / 02:33
0
answers

FireBird gets lost with two indexes with Date fields

I have SELECT relating two tables with INNER JOIN , in each of the tables I have about 600,000 records. In the main table of SELECT , I have two fields of type Date . None of the fields have null values, and there are in...
asked by 18.04.2018 / 20:35
0
answers

Using two databases in a PHP + Codeigniter application

I know that this question has been asked before, but the ones I have been able to search for none helped me, I have a PHP + Codeigniter in> I have a select of the company I'm going to use the bank: if ($this->input->post('empresa') =...
asked by 13.04.2018 / 13:22
0
answers

Error creating Trigger

create or alter trigger CAD_TERCEIROS_BI0_CPF_CNPJ for CAD_TERCEIROS -- cria a Trigger active before insert position 0 -- Posição que a trigger vai ser executada as begin if (exists(select -- faz a verificação se já existe 1...
asked by 11.04.2018 / 19:59