Questions tagged as 'firebird-2.5'

Tagged questions
0
answers

Error procedure holiday

Good afternoon guys, I'm trying to create a procedure and I can not solve my error even after several searches on the net, if you can help me, the error that appears is this: can not format message 13: 393 - message file C: \ WINDOWS \ firebi...
asked by 01.12.2018 / 18:28
0
answers

Problem inserting firebird data into ubuntu

I am using firebird in Ubuntu and when performing an insert the following error appears:    invalid request BLR at offset 230; function STRLEN is not defined; module name or entrypoint could not be found [SQLState: HY000, ISC error code: 3355...
asked by 23.11.2018 / 14:49
0
answers

Save image in Firebird with C #?

I created a form to register ( CRUD ) and I need to save the photo of the product or person for each register, until I found some things on the Internet with OpenDialog , but nothing conclusive with Firebird . Is the photo...
asked by 16.09.2018 / 14:21
0
answers

Merge PDF from the Firebird database

Hello, I'm using firebird database, and I am pulling pdfs from a blob field, however, I tried to use the FPDF and FPDFI library, however it ends up generating the following error : Atenção file_get_contents() expects param...
asked by 27.08.2018 / 13:35
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
1
answer

How do I store the value of the field returned with the "insert" command in a variable?

I have a Procedure that performs the "inserts" and "updates" in the tables. The need to create it was to try to centralize all the scan functions before inserting or updating records. Today there was a need to return the value of the table's "...
asked by 15.11.2017 / 03:52
1
answer

Firebird with restfull service and web api in C #

Hello, within a project I came across the following situation, I need to replicate information from a Firebird Desktop db to a db SQL Server Web, as both architectures do not talk to each other, the solution found is an api web application and wo...
asked by 19.09.2017 / 03:04
1
answer

Firebird 2.5 Querying a procedure

I'm using this code to bring all the calls from the previous months being -1 last month, -2 the previous month to last month, however I need to bring the 3 results (-1, -2, 3) What should I change? SELECT COUNT (*) FROM R_ATENDIMENTOS_TRIMES...
asked by 05.07.2017 / 20:25
2
answers

SELECT on a date in the range of ONE entered date and the date of the next record

How to generate a select that brings the date between an informed date and the date of the next record? In the Cargos table I only have a date, not a data_inicio and a data_fim , and I need to know the date between th...
asked by 31.05.2017 / 15:13
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