Questions tagged as 'firebird'

Tagged questions
2
answers

Rename table in firebird

How to rename table in firebird 2.5 ? I'm using query : ALTER TABLE cliente RENAME TO clientes; , but the error appears:    invalid toke 'rename'.     
asked by 16.01.2017 / 15:22
1
answer

ProgressBar and BackgroundWorker in C #

I'm creating an application with Firebird 2.5 in which I need it to read a .sql file with instructions to populate the database if these processes have not yet been done, because it is a bit long and because I do not know I want to...
asked by 14.01.2016 / 21:45
1
answer

Use the Execute block in SQL

Is there a way to find two fields (in different tables), compare them and if they are different to perform an update? Could you give me a brief example if there is any way, using EXECUTE BLOCK .     
asked by 15.06.2015 / 15:47
2
answers

What is the cause of using SELECT null FROM RDB $ DATABASE

I'm not understanding this SELECT null FROM RDB$DATABASE : SELECT CK.IDCHEK, CK.DESCHE, (SELECT null FROM RDB$DATABASE) AS ENTEGU FROM TC_CHECKL CK ORDER BY CK.IDCHEK It looks like it goes into an internal table of the b...
asked by 20.02.2014 / 15:20
1
answer

How to separate text words from a column with commas?

Is there a function ready in Firebird 2.5 that is the inverse of the list function? When you do a select list(campo,',') from tabela I want to get the value of a field in a single column separated by a comma, I wanted a function that sep...
asked by 02.05.2014 / 14:33
2
answers

SQL using sum

I have the following structure: | Data |Quantidade|QTCxVer|QTCxBra| |04.09.18| 10 | 1 | | |04.09.18| 30 | | 3 | |04.09.18| 40 | | 4 | |04.09.18| 50 | 5 | | |05.09.18| 20 |...
asked by 11.09.2018 / 18:50
2
answers

Using case in field null

I have the following structure tb_bulletin: |Cod|boletim|dt_enviado| | 1 | N | NULL | | 2 | S |24/08/2018| | 3 | S | NULL | | 4 | S |23/08/2018| | 5 | S |23/08/2018| | 6 | S | NULL | | 7 | N | NULL |...
asked by 24.08.2018 / 15:19
2
answers

CreateDatabase Delphi VCL

How to create the database automatically if it does not exist, same in the app of Delphi Android, but I want to do with Delphi VCL. I want my first run application to automatically create the database where I'm going to run scripts to genera...
asked by 21.09.2017 / 16:03
1
answer

Model-relational in firebird with C #

Developing a small C # project with Visual Studio, firebird and ibexpert. With the tables NOT RELATIONSHIP I run everything right. But I need to relate CLIENTE 1: N to BONUS E SAIDA . I am not able to develop the following re...
asked by 23.09.2014 / 05:02
3
answers

Relationship between tables

I have the following tables: TB_ESTOQUE |COD_PRODUTO|QT_DISPONIVEL|COD_FILIAL| | 0856322 | 5 | 41 | | 0856351 | 2 | 41 | | 0856322 | 9 | 114 | | 0856720 | 3 | 20 | | 08563...
asked by 09.10.2018 / 16:41