Questions tagged as 'firebird'

Tagged questions
1
answer

Delphi XE7 / XE8 - Refresh in database (real-time update)

I have two systems interconnected, one saves a record in the database and another reads the saved record, I currently use a timer to refresh the bank on the system that reads, so it picks up every 5 seconds that was saved by But I do not think i...
asked by 07.05.2015 / 18:50
1
answer

Concatenate columns and some with NULL value

I'm doing a select and concatenating the columns, when a column has value NULL (has no value) the entire line gets NULL follows an example: select 'teste'||CONTROLE||','||CODIGO||','||DATA||','||HISTORICO from tabela The res...
asked by 13.08.2015 / 15:47
2
answers

Control of high demand stock with firebird and / or mongodb

I'm thinking of migrating my ERP (currently in Java) from a relational database (currently in Firebird) to a NoSQL (probably MongoDB). I am planning and trying to anticipate possible problems. The goal is to build a control that will never let t...
asked by 15.01.2018 / 16:30
2
answers

How to use Firebird WITH LOCK with Delphi FireDac

I am trying to block a table on my system in order to prevent other users from entering the system when the procedure is running, how can I do this using the "WITH LOCK" / strong> with "FireDac" ? Does this eating lock the table for writi...
asked by 16.11.2017 / 19:15
2
answers

Update using values contained in another table

How can I do an update on a table by setting the value of a field with the same value contained in another table for all records? I have a 'product' table and a 'mov product' table. I want to update the information related to the cost price i...
asked by 29.06.2018 / 14:06
1
answer

Performance with Exists

One colleague mentioned that when doing EXISTS in SQL, it is recommended to use DISTINCT 1 to improve performance. For example, instead of doing: SELECT * FROM CLIENTES WHERE NOT EXISTS (SELECT CODCLI...
asked by 03.04.2018 / 15:23
1
answer

How to get only timestamp time?

I have a timestamp column in my table and I need to pick up only those time values. Example of how you are registered: 30.12.1899 17:03 Example of how I need to display via select: 17:00 I got it this way: SELECT CASE WHE...
asked by 16.08.2017 / 22:07
1
answer

Signing the last SQL record

I have the following SQL: select cod_nota, cod_local, cod_produto, valor from pedido order by cod_nota,cod_local,cod_produto With the result: |cod_nota|cod_local|cod_produto| Valor | | 501 | 01 | 124714 | 150,00| | 501 |...
asked by 28.03.2018 / 19:42
2
answers

Update with SET from another table

I'm trying to do an update with JOIN ... The following statement was just a kick, to get the idea of what I want to do: UPDATE PCPSEQPROC_001 PCPSEQPROC SET PCPSEQPROC.ID_PCPSEQPROC = PCPSEQ.ID_PCPSEQ INNER JOIN PCPSEQ_001 PCPSEQ...
asked by 29.03.2018 / 21:40
1
answer

Query returning duplicate values

People I posted here in the topic SQL Query with Duplicate Items I just have another question I have sql: SELECT TABNOV.CODIGO_ANDAMENTO, TABNOV.NUMERO_PROCESSO, TABNOV.INSTANCIA, TABNOV.DESCRICAO_ANDAMENTO, TABNOV.ACESSO_PUBLICO,...
asked by 13.07.2017 / 20:46