Questions tagged as 'firebird'

1
answer

How to make an insert in mysql with data coming from a SimpleDataSet

I have a SimpleDataset with data from a Firebird location. I have to make a Insert in Mysql . How do I do this? Other SqlConnect and another SimpleDataSet ? How to do insert with data from this SimpleDataSet ( firebi...
asked by 14.07.2016 / 01:56
2
answers

Perform an overall sum with all fields

I have the following tables: tb_product, tb_movement COD_PROD | DESCRICAO | TIPO | |01 | CEBOLA | ALIMENTO | |02 | ARROZ | ALIMENTO | |03 | CARNE | ALIMENTO | |04 | COCA-COLA | BEBIDA | |05 | PI...
asked by 10.11.2016 / 12:47
1
answer

How to create a view that lists the domains in Firebird 2.5?

Does anyone know how to mount a SQL that lists the "domains" in a Firebird 2.5 database? Thankful.     
asked by 16.06.2016 / 16:30
2
answers

Firebird Tool - Which

What would be the most used software for managing firebird database, if possible, show me free and paid options.     
asked by 30.03.2016 / 14:16
1
answer

How to develop in Android Studio with the Firebird database?

Can not connect to an external Firebird database through Android Studio? should I use eclipse? Researching a lot how to make this connection, I saw in some posts that android can not make this connection. And where can I download android s...
asked by 18.05.2016 / 13:46
1
answer

How to perform statistical fashion in SQL?

Working for a telephone charging system company, all connections generated by the PBX are billed by the system and stored in a table called cadcha . cadcha ------------------------------------------ nreg | telefone | ramaldestino | teldata...
asked by 15.12.2015 / 15:18
1
answer

Insert several data in ibexpert

I'm not sure what to do, but I'm not sure how to do this.    Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown   - line 4, column 1. (. I'm trying to insert as follows: INSERT INTO CIDADE (CODIGO,NOME,ESTADO) VALUES...
asked by 02.02.2016 / 12:43
1
answer

save in the txt file the result of the sql query in firebird using Delphi

I need to save the result of a query inside the txt file by separating by a delimiter, I am extremely new to delphi and firebird, so any help is welcome code below: procedure TForm1.btPesquisarClick(Sender: TObject); var arquivo: TextFile;...
asked by 13.12.2018 / 15:15
1
answer

Sql using left join

I have the following tables: TB_ESTOQUE |PRODUTO|QT_DISPONIVEL|COD_FILIAL| |0856322| 5 | 41 | |0856351| 2 | 41 | |0856322| 9 | 114 | |0856720| 3 | 20 | TB_FILIAL |COD_FILIAL|COD_L...
asked by 08.10.2018 / 21:57
1
answer

Display BLOB text

I am having the following problem, in a precise report displaying a field of the request that is as BLOB. And when I run the search it returns a strange code instead of the field information. $sql = ibase_query("SELECT CAST(OBSERVACAO AS CHAR(...
asked by 30.10.2017 / 19:13