Questions tagged as 'firebird'

Tagged questions
0
answers

Return image (BLOB) in UDF Firebird / Delphi

I'm looking for a file (JPEG) and trying to return it in a Firebird UDF, through a BLOB field. It is running for small files, but large files the image is sent cut off. Anyone have any ideas? function LoadPicture(AFilePath: PAnsiChar; ABlob: P...
asked by 13.03.2018 / 21:09
1
answer

Transfer fields from one table to another

Good morning, is there any way to transfer fields from more than one table to another? I have an outdated database and need to create the new fields in multiple tables. Is there any query that does this, I use firebird 2.1 with IBExpert Ex...
asked by 13.03.2018 / 14:39
0
answers

Display images of a BLOB field from a firebird database in PHP

I think someone will feel right in saying that this question is a duplicate, but I disagree, do not have a question that simply and objectively answers a method of displaying an image of a blob in PHP , using Firebird . From what I was ab...
asked by 20.02.2018 / 03:40
1
answer

Why were the views slow after migrating the data via script in Firebird 2.5?

I'm working on a standardized database. I recently refacted her (A) structure by renaming all existing PKs and FKs, because they had the names that are automatically generated. When migrating data from another base (B) to this refactor (A), I'm...
asked by 28.02.2018 / 22:07
0
answers

Data migration

I work with firebird database, so sometimes we need to convert data from another type of database to FB, and we use delphi to do this process. I'm still a beginner and I do not know anything about it, would anyone have any documents that explain...
asked by 05.02.2018 / 23:56
3
answers

Select on a date and the return can not be null

I need the return of a date, if it is "Null" in the DB, return another date or other than "Null."     
asked by 17.01.2018 / 11:44
1
answer

SQL grouping information

I have the following sql statement: SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR' AND TIPO_CAMPANHA = 5 AND DT_CAMPANHA = '01.08.2018' UNION SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR'...
asked by 24.01.2018 / 17:47
1
answer

Firebird JPA returning null values

When I try to get some records from the database, some fields are null, even though the table is not null! Any idea what might be causing this behavior? I'm using Java 8 , Hibernate 5.2.4 , Jaybird 3.0.3 . As soon as I'm picking up P...
asked by 21.01.2018 / 20:03
0
answers

Masking CNPJ in firebird

I need to mask my CPF / CNPJ field directly in firebird, I tried the command below but it shows error, can anyone help me? UPDATE EMPRESA SET EMP_CPF_CNPJ = SUBSTRING(EMP_CPF_CNPJ from 1 for 2) + '.' + SUBSTRING(EMP_CPF_CNPJ from 3 for 3) + '...
asked by 20.12.2017 / 11:27
1
answer

Image conversion with PHP

It's my first day with php and I'm doing a select that returns me an image, how do I render this image. Here is my select and the image return: class CooperMaisController { public function getItens(){ $connect = OpenConnection(); $que...
asked by 13.12.2017 / 14:22