Questions tagged as 'firebird'

Tagged questions
1
answer

Two tables returning a single result

select cliente.codcliente, cliente.dt_cadastro from cliente where cliente.codcliente in ('00000224', '00000170', '00061825', '01009838') order by cliente.codcliente selectnfsaidc.codcliente,nfsaidc.numnf,nfsaidc.dt_emissao,nfs...
asked by 20.10.2017 / 18:39
1
answer

SQL Delete with join, union in Firebird

How would a Delete SQL Example with Join or Union be? I've seen here in stackoverflow how to do in MySQL in sql Server more in firebird I have not found or found in other forums. my SQL looks like this DELETE FROM ANDAMENTOS_PROCESSUAIS WHERE...
asked by 01.07.2017 / 14:35
1
answer

Select in Firebird with PHP using conditions

How do I correctly include the select below in php code? I'm having trouble making WHERE . SELECT ESTOQUES.produto, ESTOQUES.cor, ESTOQUES.tamanho, ESTOQUES.filial, CODIGO_BARRAS.barra, ESTOQUES.saldo FROM ESTOQUES,...
asked by 21.09.2017 / 15:01
1
answer

Querying results using SQL or XAILER programming tips

I have the following relationship between 3 tables: 'SELECT contareceber.codcontareceber, contareceber.codorganizacao, contareceber.dtdocumento, contareceber.dtvencimento, contareceber.valortotalbruto, contareceber.valortotalrecebido, conta...
asked by 08.06.2017 / 18:30
3
answers

How to return empty record of a Select?

I'm creating a system in PHP and it has a Script that selects the module data requested by the user. Script creates the form to display and edit the data as per the field information of the tables. The problem I'm facing is that when the r...
asked by 14.06.2017 / 21:07
1
answer

How to synchronize auto increment keys between different databases in Firedac?

I'm looking at how auto-increment fields work in Firedac, using Delphi xE7, and I've been able to put together an example documentation that syncs two master-details tables with the correct key. The doubt arose when I wanted to mirror my Firebir...
asked by 28.12.2016 / 03:06
1
answer

Select in Mysql and insert in Firebird [closed]

How to do a "select" in the Mysql / Mariadb database and "insert" the data collected in firebird (interbase).     
asked by 21.12.2016 / 19:51
1
answer

Entity Framework does not convert INTEGER from Firebird to long from C #

I'm doing some testing with Entity Framework by mapping and migrating a database from a legacy system. Scenery Where I have a table similar to this: TESTE -------------------------------------- ID INTEGER NOT NULL, NOME VARCHAR(...
asked by 13.09.2016 / 17:01
1
answer

How to set the generator (from firebird) to an Entity framework 6 model field?

For example: I have the following table: TABLE_EXAMPLO ----------- ID NAME And the following Generator: TABLE_EXAMPLO_GEN How would I map the entity so that the Entity Framework can call the generator for new record...
asked by 12.09.2016 / 20:36
1
answer

How to create a select in firebird?

Create a select listing 03 fields of any table, sorting the data by the 2nd field. I am very weak in firebird can anyone tell me how I would do this?     
asked by 21.06.2016 / 00:51