Questions tagged as 'firebird'

Tagged questions
1
answer

Django Authentication with Legacy Database

I am developing a project with a legacy database (Firebird), and I was able to configure settings.py and it is working with the database. At the time of creating a login using forms, I am not able to create authentication with the database, a...
asked by 12.11.2014 / 19:49
1
answer

Problem with Django authentication

I'm having trouble validating login, I'm using a legacy firebird 2.5 database. Could someone help me?     
asked by 11.11.2014 / 16:18
1
answer

Using Count with select all

I want to make a sql by counting the records with duplicity: select produto,matricula,data,fornecedor, count(*) from tb_teste group by produto,matricula order by fornecedor In this form of the error, sql requests the fields data,forn...
asked by 14.12.2018 / 18:33
1
answer

PHP + FIREBIRD - Bring result of table relationships

In IBExpert the query below brings the data correctly, but when I use the same query in PHP it does not work. SELECT FUNCIONARIOS.nome, CNPJ, cod_funcionario, LOGRADOURO,...
asked by 26.12.2018 / 14:20
1
answer

Left Join Slow in Firebird 2.0

I have two tables: Sale > 100 Records Primary key fields: Invoice Payments > 200,000 Records Primary key fields: Id, Invoice, SalesType, Document. I have the following SQL: Select V.FATURA, P.ID From Venda V Left Join Paga...
asked by 03.10.2018 / 20:32
1
answer

Error EF Update Method with Firebird 2.5

When I try to update an entity Firebird is returning this error "Implementation limit exceeded block size exceeds implementation restriction", simply get the entity of the bank and has to update without changing anything in it, so I saw the link...
asked by 29.06.2018 / 20:55
1
answer

Show message if IN record does not exist

Hello, can someone help me with the following type of query in firebird, so I want to put several numbers of cpf in the IN of a query and if the cpf exists in the table show the data, but if it does not exist show a column indicating that does no...
asked by 11.06.2018 / 21:46
1
answer

Problem with full outer join doing the filter with where

Friends, I have a database with the following tables: types id | nome 1 | Duplo 2 | Triplo availability data | tipo | ocupado | manutencao | referencia 01/03/2018 | 1 | 1 | 0 | 54684 01/03/2018 | 1 |...
asked by 26.02.2018 / 21:01
1
answer

How to improve select performance

I have to use firebird, but I do not get very well with the database, I made the select as follows: select first 5 skip ((1 - 1) * 10) distinct PRO.CODIGO, PRO.NIVEL_INTERESSE, PRO.DATA_RETORNO, PRO.RESPONSAVEL_PROSPECT, PRO.EMPRESA_PROSP...
asked by 23.11.2017 / 17:13
1
answer

How to run PHP + Firebird in Docker?

I'm trying to run / create a container in docker with PHP + Firebird, I found a container that runs Firebird , I found another one that runs PHP and Firebird, but when I try to consume the database: $conn = ibase_connect('localhost:/databas...
asked by 20.12.2017 / 02:13