Questions tagged as 'firebird'

Tagged questions
0
answers

How to relate these tables, returning specific values?

[Firebird] sgbd - IBExpert I need to know how I can relate these two tables (comment below), so that I get the following results: TABLE: CONTARECEBER DTDOCUMENTO (date you entered the system) DTVENCIMENTO (date the document will...
asked by 01.06.2017 / 15:54
1
answer

How to convert dates in varchar to date in SQL 'Firebird'?

How can I convert dates to varchar for date ? I'm having difficulty performing cross-date searches because of this discrepancy in the database where I query. When I enter my line of code: select * from TAB_FATURAMENTO where cd_cliente li...
asked by 02.06.2017 / 14:14
1
answer

Compare Date End of first record with Start Date of Second

Hello. I'm having trouble crafting a SELECT that checks if the End Date of the first record of the query is greater than the start date of the second. The database in question is for notes, and for some reason, some notes have a start da...
asked by 01.06.2017 / 22:35
0
answers

Double Precision Firebird on PDO

Good afternoon, I'm doing a query in a firebird table using PDO PHP, and in a specific field this table is returning all equal values in all records, this field is of type Double Precision. Is it some PDO bug? Has anyone ever experienced this ?...
asked by 12.05.2017 / 19:24
1
answer

Using Case in Order By with union

I'm having trouble using Order by with Case in Union, so it works: select tb_a.nr_rua, tb_a.cod_altura, tb_a.cod_posicao, tb_a.cod_lado where ...... union all select tb_b.nr_rua, tb_b.cod_altura, tb_b.cod_posicao, tb_b.cod_lado where ...... or...
asked by 10.05.2017 / 21:20
0
answers

Doubts Select / PHP

I'm making a select this way. $stmt = $lokos->prepare("select CODIGO_PROGRAMA, VERSAO_PROGRAMA, DATA_INSERCAO, DESCRICAO_ALTERACAO from programas_padrao Order by DESCRICAO_ALTERACAO D...
asked by 25.04.2017 / 17:08
0
answers

When I give select to any table in my FIREBIRD database, I can not "decipher" the varchar

So,I'mhavingproblemswiththisbank,Itrytogiveaselect.onanytableIgiveselectthevarcharwilllookthiswayasyoucansee.IalreadychangedthecharsetforeverythingIwantedandcontinuedinthesameproblem I'm using IBexpert     
asked by 10.03.2017 / 19:54
1
answer

Delete records dynamically in SQL

I need to delete multiple table data in different SGDB types, but I do not know how to do this in a practical way. I need to keep 10 records in the tables and I need to delete all the remaining ones, but I can not do this with the command:...
asked by 11.01.2017 / 20:26
0
answers

Why is the timestamp field in the firebird database shown differently in a Ruby on Rails application?

I have a legacy Firebird 2.5 database. Access it via IBExpert 2016.9.4.1 This database is part of a request management system that is being migrated from a Delphi 10.1 Update 2 application to a Ruby(2.3.3) on Rails(4.2.7....
asked by 06.12.2016 / 18:27
0
answers

Reducing images in Firebird

I have a Firebird bank with some images saved in high definition, does anyone know a method to reduce the images without having to remove them from the bank?     
asked by 28.11.2016 / 19:12