Most voted "firebird-2.5" questions
26 questions
Sort by count of
-
3
votes2
answers264
viewsJava + Firebird connection returning Null
My connection string with the Firebird database returns null. Follows below code: public class ModuloConexao { public static Connection conector(){ //criação da varáivel conexao Connection conexao =…
-
3
votes2
answers490
viewsUsing case in null field
I have the following structure tb_boletim: |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 |…
-
3
votes1
answer555
viewsProblems with Python3 in connection with Firebird2.5
I made this Python code (basic connection with Firebird): import fdb con = fdb.connect( host='192.168.1.17', database='/home/firebird/questor.fdb', user='sysdba', password='masterkey' ) cur =…
-
2
votes2
answers1314
viewsConnection limit
System in Delphi - Database Firebird 2.5. I have a server with 25 "files" of databases, one from each client. Each customer has on average 10 accesses via TS to connect to our server. However, when…
-
2
votes1
answer29
viewsUsing case to match fields
I have the following structure --------------------------------------- |DT_Ven | VLR_CONTA|DT_QUI | VLR_QUI| |-------------------------------------- |30/07/20| 84,00|NULL | 84,00| |03/08/20|…
-
1
votes0
answers1604
viewsUnavailable Database error when trying to connect Clientdataset using Firebird local base
I am developing an application in Delphi 2010 and I’m using Firebird 2.5. I created a Datamodule and put a Sqlconnection, Sqldataset, Clientdataset and right-clicking on the Clientdataset in the…
-
1
votes1
answer97
viewsFirebird utilities on C#
How to use library resources Firebird in the C#: FbValidation, FbLog and FbStatistical? I couldn’t find any documentation of Firebird that could help me.…
-
1
votes1
answer241
viewsAccent php - Firebird
I’m making a web module for an old system that uses Firebird. I made the connection using PDO, but when I do a query using some special character it does not return results. If you don’t use a…
-
1
votes1
answer59
viewsFailed to restart Firebird by PHP
I have a virtual server with Linux-Debian operating system, which is configured as Nginx web server and Firebird database. I have a script that performs a Firebird restart routine and executes it…
-
1
votes1
answer345
viewsCompare End Date of the first record with Start Date of the second
Hello. I’m having trouble drafting a SELECT that checks whether the End Date of the first query record is greater than the start date of the second. The database in question is of notes and for some…
-
1
votes1
answer189
viewsConstruction CASE Firebird
I need to build a structure CASE in the SQL Firebird only you’re not accepting the way I’m doing. SELECT CONTAS_RECEBER.ID, CONTAS_RECEBER.DT_VENC, CONTAS_RECEBER.TIPO_OPERACAO,…
-
0
votes1
answer216
viewsSpecial characters Webservice C# SQL X Base Firebird
I have an integration made by Web-service (asmx) , C# e SQL Server. This Web-Service is consumed by a third-party software that uses Delphi and Firebird. The problem is that when integrating a…
-
0
votes0
answers228
viewsWhy is the timestamp field in the Firebird database displayed differently in a Ruby on Rails application?
I have a database Firebird 2.5 legacy. Access it via IBExpert 2016.9.4.1 This database is part of a request management system that is being migrated from an application Delphi 10.1 Update 2 for an…
-
0
votes1
answer138
viewsFirebird 2.5 Query of a trial
I am using this code to bring all calls from previous months being -1 last month, -2 the month before last month, but I need to bring the 3 results ( -1, -2 ,-3 ) which I must modify ? SELECT COUNT…
-
0
votes1
answer516
viewsFirebird 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 db Firebird Desktop to a db SQL Server Web, as both architectures do not talk to each other, the…
-
0
votes1
answer181
viewsHow to store the returned field value 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 check functions before entering or updating records. Today the need…
-
0
votes1
answer160
viewsProblem with full Outer Join filtering with Where
Friends, I have a database with the following tables: guys id | nome 1 | Duplo 2 | Triplo availability data | tipo | ocupado | manutencao | referencia 01/03/2018 | 1 | 1 | 0 | 54684 01/03/2018 | 1 |…
-
0
votes1
answer28
viewsWhy were views slow after migrating data via script in Firebird 2.5?
I’m working on a standardized database. I recently refactored her structure (A) by renaming all existing PK and FK, because they had the names that are automatically generated. When migrating data…
-
0
votes0
answers82
viewsSave image in Firebird with C#?
I created a form for registration (CRUD) and I need to save the photo of the product or person for each registration, until I found on the Internet some things with OpenDialog, but nothing…
-
0
votes1
answer147
viewsError Method Update EF Core with Firebird 2.5
When trying to update an entity Firebird is returning me this error "Implementation limit exceeded block size Exceeds implementation Restriction", simply take the entity of the bank and have it…
c# firebird entity-framework-core firebird-2.5asked 5 years, 12 months ago Lucas Riechelmann Ramos 521 -
0
votes1
answer148
viewsWhat is the Difference between Select and Run in a Procedure?
There is some difference between making a Select to call the Procedure and giving a Execute in the Procedure, for example, in select a Procedure is in Read-Only mode and in execute no?
-
0
votes1
answer189
viewsQuery in SQL/Firebird grouping a sum by nature
I’m trying to make a Query in the product table to return to me the following information below: I’m trying to do it in a grouped way by totaling the values. There is a spine by name nature, that…
-
0
votes0
answers43
viewsDelphi - Recover code on Dbgrid after registration
Hello ! I have a Dbgrid connected to the temporary table (Tfdmemtable) with data of products that were imported from an XML and from a product I call at runtime the product registration form filling…
-
0
votes0
answers208
viewsPhp 7.3 I am unable to connect to Firebird
Person who can help me I’m already a week cracking my head I bought a system and the bank and Firebird file fdb version 2.5 I want to assemble another program but I need to align the banks, until it…
-
0
votes2
answers64
viewsSelect returning null values in the database
SELECT S.ID_SALES, S.ID_CLIENT, C.FULL_NAME, S.SDATE, coalesce(S.billed, 'N') BILLED, P.product_description product, I.amount, I.unit_cost, I.unit_cost * I.amount SUBTOTAL, coalesce(I.discount, 0)…
-
-1
votes1
answer963
viewsWhat is the best connection method between PHP and Firebird?
I use the functions ibase_ to connect and manipulate data on Firebird with the PHP. I saw that many people also use pdo_firebird. The version of Firebird that I use is 2.5. After all, I am using the…