Questions tagged as 'firebird'

Tagged questions
2
answers

How to close connection to the Firebird database

I'm trying to create a web application in ASP.NET C #, but I'm not sure how to do it. p> string conDDNS; FbConnection conexaoDDNS; protected void Abrir_Fechar_Click(object sender, EventArgs e) { try { this.conD...
asked by 12.02.2016 / 19:49
0
answers

Problem with Firebird 3.0 connection with Java 1.8

I'm having problems trying to connect to Firebird 3.0 using Jaybird 2.2.7, while running the Firebird 2.5 test I can connect to the database, but when I try to log in to Firebird 3.0, I enter the exception. Following the images in the excepti...
asked by 13.05.2015 / 15:37
2
answers

Exclusive access to a table in firebird Has How?

Would you like to open a table in Exclusive mode in Firebird by Delphi preventing other users from opening the Table? I use Delphi 10.1 and FireDac to connect to the database.     
asked by 08.11.2017 / 12:52
1
answer

How to open an .fdb file?

I need to open a database file ( .fdb ), but I do not know how. What should I do to open this file? There is a list that I want to pass to Excel.     
asked by 12.02.2016 / 15:53
2
answers

How to display data in a dbgrid

I'm using SQLConnection, SQLDataSet, ClientDataSet, DataSetProvider, ClientDataSet and DataSource . I need to display the data in dbgrid , but I'm not sure how to do this. No FormCreate should I open the connectio...
asked by 01.07.2016 / 14:09
1
answer

Embedded database with C # [closed]

I'm developing a local desktop application. As there will be no database servers, I have studied some, such as Firebird, SQLite, Access and even Localdb. But I still feel "lost" in which to work. I know the general choice is SQLite, but I did no...
asked by 06.11.2015 / 13:45
1
answer

Character exchange in a position - sql

I want to replace the third character of a string in firebird, example: 00028 by 00128, 00029 by 00129 ... Could someone help me, I tried to see by replace, but I can not determine the position     
asked by 29.05.2018 / 16:07
1
answer

Generator x Sequence in Firebird

When using Generator and how much do you use Sequence in Firebird? What is the difference between the two? Is there a performance difference?     
asked by 03.10.2016 / 02:56
2
answers

Count on Firebird 3.0 Bigint X FIrebird 2.5 Integer

On my system, after migrating from Firebird 2.5 to 3.0 , many reports and other functions began to give problem stating that expected was Integer and current is LargeInt . I took a look and saw that some searches with...
asked by 08.12.2016 / 11:17
2
answers

Select dates that are not in the table

I need to set up a report for a customer with the billing for each day of a given month. So the beauty, the problem is that now he wants even the days that have no sale, are shown in the table with the value showing zero. For example, this my...
asked by 14.08.2018 / 13:32