Most voted "firebird" questions
Firebird is a relational database management system based originally on the code of another relational database management system, Interbase. In its version 6.0, Interbase had its open source for the community that created the Firebird project.
Learn more…347 questions
Sort by count of
-
2
votes0
answers266
viewsDelphi sql using coalesce
In Delphi I have Tibquery: select * from TB_PRECO where coalesce(DT_CAMPANHA,'') = coalesce(:DT_CAMPANHA,coalesce(DT_CAMPANHA,'')) and coalesce(DT_VECTOPRECO,'') >= coalesce(:DT_ATUAL,…
-
2
votes1
answer46
viewsSignaling the last SQL record
I have the following SQL: select cod_nota, cod_local, cod_produto, valor from pedido order by cod_nota,cod_local,cod_produto With the result: |cod_nota|cod_local|cod_produto| Valor | | 501 | 01 |…
-
2
votes1
answer619
viewsUsing in SQL coalesce with Date
I have the following question. In SQL your doing so works. ...and coalesce(tb_cadastro.cod_produto,'') = coalesce(:COD_PRODUTO, coalesce(tb_cadastro.cod_produto,'')) and ... Where the COD_PRODUTO is…
-
2
votes1
answer302
viewsBetter shape in Firebird, taking safety and lightness
I’m developing a software in Delphi, using Firebird. My goal is to have a lightweight, fast, but, software that has security, regarding errors, corruption in the bank, resist as far as given to…
-
2
votes1
answer50
viewsI can’t run a trial in Firebird
Good afternoon guys. I need to enter a record in the database but no duplicates. I tried this: create procedure My_Proc as begin if(not exists(select * from alunos where nome = 'Mateus')) then…
-
2
votes2
answers406
viewsSelect dates that are not in the table
I need to compile a report for a client with the billing for each day of a given month. Until then beauty, the problem is that now he wants even the days that have no sale, are shown in the table…
-
2
votes1
answer762
viewsFailed to connect database: Connection Lost to database - Firebird and Delphi application
I have a server with more than sixty client databases that currently operate with Firebird 3.0.3.32900 and an application in Delphi that is responsible for synchronizing logs from end to end. For…
-
2
votes2
answers226
viewsLaravel and Sqlite database
Think of me, you have server Laravel with a Sqlite database configured, access to this database in thesis is to be faster, since it is on the server itself. Follow the example: user -> server…
-
2
votes1
answer223
viewsHow do I change the path of my database when running the program?
I’m starting to program with the Delphi XE8 and using Firebird 2.5. I managed to implement my database and it’s working all right. The problem I’m facing now is that as I change from computers to…
-
2
votes1
answer23
viewsI want to group database data (Firebird) to send emails
Good, I am selecting the data for sending the email in this SELECT: SELECT V.id_venda_cab, V.id_cliente, V.Total, C.nome, i.id_produto, p.descricao, C.email FROM VENDA_CAB V INNER JOIN CLIENTE C ON…
-
2
votes2
answers48
viewsSQL showing records if they only meet different conditions than usual
I have a slightly different situation, tried different conditions but none brought the desired result. My need is this: I have a base containing authors of books and their respective works. I need…
-
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|…
-
2
votes0
answers28
viewsReturn field calculated by Firebird Generator (Firedac)
I have Tfdquerys created at runtime for the purpose of entering records into my database. Table: CREATE TABLE TABLETESTE ( ID INTEGER ); SET TERM ^ ; /* Trigger: TABLETESTE_BI */ CREATE OR ALTER…
-
1
votes3
answers2037
viewsSuspend function in Firebird
What is the function of suspend in a Procedure in the Firebird?
-
1
votes1
answer295
viewsPurposeful Cartesian product
I need to create a purposeful Cartesian product, for a report on Fast Ports that is to multiply my data by a given number EX: select cli.cdclifor, CLI.nmCliFor from cadclifor cli where cli.cdclifor…
-
1
votes1
answer930
viewsError running a Firebird Trigger
I have the following Trigger generated in my database: SET TERM ^ ; CREATE OR ALTER TRIGGER ATUALIZA_CODNCM FOR EST_ADICIONAIS ACTIVE BEFORE INSERT OR UPDATE POSITION 0 AS begin UPDATE…
-
1
votes2
answers1047
viewsGenerate Sequence Records with Clientdataset (Multiuser)
Guys I have the following scenario: Order Table with Company, Numeropedido that are primary key. Other fields like Customer, Value, ect... I have an Sqlquery, a Datasetprovider and a connected…
-
1
votes1
answer197
viewsUsing Gfix in a C#
I am developing an application in C# and I need to pass the Gfix in a Firebird database, I thought to run a prompt window and pass the commands of Gfix to her, but I am not succeeding. Also I need…
-
1
votes1
answer1120
viewsChange zip code column by inserting dash in Firebird
I have a table of cities where I own the Zip Code. The data looks like this: 89620000 I’d like to leave it at that: 89620-000 How can I do this in Firebird?
-
1
votes1
answer781
viewsHow to allow the insertion of information in the database using Dblookupcombobox?
I have a DBLookupComboBox capturing data from the table Species for the user to select what they need, after that this data is saved in the table Animal. My question is how do I manage to allow the…
-
1
votes1
answer4302
viewsFirebird - transaction monitoring
I updated my Firebird to the versão 2.5 and would like to view the transactions, I saw in several links that the command: SELECT * FROM mon$statements solves, but this command gives me a mistake:…
-
1
votes2
answers23894
viewsUnable to locate driver (Pdoexception "could not find driver")
I’m trying to make a connection to my FIREBIRD database, but when I organize it right, I put the IP where it is located etc. The message appears: COULDN’T LOCATE DRIVER ON c/wamp/www//// What should…
-
1
votes0
answers272
viewsScreen login C# with database Firebird with error
I am doing a project and with Firebird database but, at the time of authenticating the user, is returning true even if there is no user registered in the database with the line if (ER.HasRows), and…
-
1
votes0
answers333
viewsInsert blob Firebird php
i am having a problem when trying to insert a blob field in Firebird my code is the seguitne $ficheiro = $this->blob_create(file_get_contents($_FILES['ficheiro']['tmp_name'])); $extensao =…
-
1
votes1
answer456
viewsHow to do Migrations and versioning with Firebird database?
I recently found this site Flyway DB where, from what I understand, it is possible to create Migrations and control the version of the database. However, I don’t think it supports Firebird. Is there…
-
1
votes1
answer640
viewsHow to use C# Windows Forms with Firebird and Object Orientation?
I recently learned a little object orientation and c#. But I am trying to create an application that is developed in c# windows Forms, with database Firebird and object-oriented. But what’s the…
-
1
votes2
answers4197
viewsFirebird - Select with date less than 10 days
I searched but did not understand how to use the function DATEDIFF() in the FIREBIRD what I need is for the query to return me records with dates up to 10 previous days from the date current. Obs:…
-
1
votes2
answers899
viewsHow to use Firebird database on network with C#?
I developed a C# Windows Forms application with Firebird database and I need to place the application with the database on a machine that will be like a server. With this, I need to access this…
c# database visual-studio-2013 firebird networksasked 8 years, 11 months ago André Morais Martins 367 -
1
votes2
answers6427
viewsExport data from Firebird
I have a client registration program linked to Firebird, but I will not use this program anymore and I need the data. Could I take the database.fbd file, which I’m afraid is all the entries and…
-
1
votes1
answer6989
viewsmb_convert_encoding vs utf8_encode()
I did an update on php on the server and identified that they were not being coded in the standard utf-8, the first thing I checked was the connection class I use, which in this case is adodb. In my…
-
1
votes2
answers601
viewsHow to use my already populated Firebird database for a web project in visual Studio 2015 using Entity framework?
I have an already populated Firebird database and would like to use this same database for a Web project in visual studio 2015. I already installed Firebird ADO.NET Data Provider and tried to give a…
entity-framework firebird connection visual-studio-2015 databaseasked 8 years, 10 months ago Victor Glauber 95 -
1
votes1
answer438
viewsDatabase loca + Node.js
I am working on a project using Node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and…
-
1
votes0
answers286
viewsUnidac uniQuery component does not return keygenerator value
I’m having trouble inserting into Firebird using Devart’s uniQuery (Delphi 7 with Unidac) component. The primary key field is in the query fieds and the component configuration is like this:…
-
1
votes1
answer667
viewsKeep database connection open in PHP
When using a PHP application with Firebird database we use the methods ibase_connect() to open the connection to the database and ibase_close() to close that connection. If the connection is opened…
-
1
votes2
answers9328
viewsFirebird Tool - Which
What would be the most used software for Firebird database management, if possible, show me free and paid options.
-
1
votes1
answer1551
viewsHow to perform statistical fashion in SQL?
I work for a telephone charging system company, all calls generated by the central (PABX) are charged by the system and stored in a call table cadcha. cadcha…
-
1
votes1
answer56
viewsAccess Violation in module 'Dbxcommondriver220.dpl'
I’m having trouble using Firebird in Embarcadero C++ XE8. Error: Access violation in module 'DBXCommondriver220.dpl'
-
1
votes1
answer2703
viewsHow to develop in Android Studio with Firebird database?
Can’t connect to an external Firebird bank from Android Studio? should I use eclipse? Searching a lot how to make this connection, I saw in some posts that android can not make this connection. And…
-
1
votes1
answer122
viewsProblem using the Jaybird
I am unable to connect in my bank using the jdbc of Firebird. the bank is very old and I can not discard it yet, I need to at least download the customer list and save on sqlite. the problem happens…
-
1
votes1
answer360
viewsHow to do Reverse Engineering via Entityframework using a Firebird data source in Visualstudio 2015?
I have an already populated Firebird database and would like to use this same database for a Web project in visual studio 2015. I would like to use a library class and generate the model using EF…
-
1
votes1
answer1191
viewsUnsupported on-disk Structure
I was developing in Delphi using Firebird 2.5. And it started to give an error when trying to connect to the local database. When trying to connect it from the following message: Error: unsupported…
-
1
votes1
answer204
viewsHow to create a view that lists Omains in Firebird 2.5?
Does anyone know how to mount an SQL that lists "Omains" in a Firebird 2.5 database? Thanks.
-
1
votes1
answer438
viewsHow to create a select in Firebird?
Create a select listing 03 fields from any table by sorting the data through the 2nd field. I’m pretty weak in Irebird someone can tell me how to do it?
-
1
votes1
answer346
viewsError : Class org.firebirdsql.jdbc.Fbdriver has Unsupported major or minor version Numbers
Guys I’m making this mistake Somebody knows what it is : An Error Occurred: java.lang.Unsupportedclassversionerror: Class org.firebirdsql.jdbc.Fbdriver has Unsupported major or minor version…
-
1
votes1
answer4170
viewsInsert various data into ibexpert
Good guys a little while ago I started using the Firebird and I have the following problem , when trying to insert some data directly in the IB Expert it returns me the following error : Invalid…
-
1
votes1
answer392
viewsError connecting with Firebird database
I’m trying to create a web application and want to use java and html. Good after everything set up and ready for a small connection test the following error occurs: Fev 09, 2016 1:28:02 PM…
-
1
votes1
answer75
viewsHow to make an insert in mysql with data coming from a Simpledataset
I have a Simpledataset with data from a Firebird local. I have to make one Insert in the Mysql. How should I do it? Other Sqlconnect and another Simpledataset? How to do the Insert with data from…
-
1
votes1
answer68
viewsBeforepost recording wrong information
In my Delphi application, when breaking an agreement with my Client I must update the operations data! So I start by deleting some customer data, the problem happens right there: procedure…
-
1
votes3
answers855
viewsTrigger to update modification date in Firebird
I have a table of clients with the fields of Registration Date of the Registry and Date of Registry Modification someone would know how to create a trigger updating the column of Date of…
-
1
votes2
answers1435
viewsMaximum size for stored procedures, Fields, etc... in Firebird
I have researched several sources and found no definitive answer to this question. I believe that this is a pertinent question because, based on this, we can create the names of database objects by…
firebirdasked 8 years, 8 months ago alexandrecrt 11