Stack Overflow
Stack Overflow

Questions tagged [interbase]

InterBase is a SQL database system for server, desktop and embedded applications, for use on Windows, Linux, macOS, iOS and Android. InterBase 2020 is the newest version and integrates with Embarcadero's RAD Studio IDE supporting Delphi and C++ development. InterBase supports connectivity from many other programming languages as well. See https://www.embarcadero.com/products/interbase for further information.

331 questions
16
votes
3 answers

How to make Firebird client application wait for row to unlock

My familiarity is with the Microsoft SQL server world using ADO (dbGo), and I have written many applications for that environment. Now I have a legacy Delphi 7 application with a Firebird 2.5 database that I must maintain. BUT I am finding is that…
nolaspeaker
  • 1,868
  • 19
  • 38
11
votes
2 answers

interbase and BDE on windows 7

OK I know this has been deprecated, and bde is older than Moses, but we have some legacy applications that have not been migrated still using bde. Has anyone been successfull in installing bde WITH the interbase sql links fully configured for…
Crudler
  • 2,144
  • 2
  • 29
  • 57
9
votes
2 answers

Firebird's SQL's Substring function not working

I created a view on a machine using the substring function from Firebird, and it worked. When I copied the database to a different machine, the view was broken. This is the way I used it: SELECT SUBSTRING(field FROM 5 FOR 15) FROM table; And this…
Mario Marinato
  • 4,441
  • 2
  • 26
  • 47
8
votes
3 answers

Firebird backup restore is frustrating, is there a way to avoid it?

I am using Firebird, but lately the database grows really seriously. There is really a lot of delete statements running, as well update/inserts, and the database file size grows really fast. After tons of deleting records the database size doesn't…
Yordan Yanakiev
  • 2,366
  • 3
  • 35
  • 82
8
votes
2 answers

Executing a script using ISQL

I'm creating a simple isql script but it's not working and I need some help to find out whats wrong with it. I need to connect to a database and execute a SQL file. This is my script called script.sql: CONNECT…
user729661
  • 81
  • 1
  • 1
  • 2
8
votes
7 answers

NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver

With InterClient 7.5.1 and 8.1.5, the creation of a new JDBC connection in Java 8 fails with java.lang.NoClassDefFoundError: sun/io/ByteToCharConverter This class seems to be referenced or used by the InterClient JDBC library. The error does not…
mjn
  • 35,561
  • 24
  • 160
  • 351
7
votes
1 answer

TClientDataSet: How to keep local data save and available when a database structure has been changed

Hello code enthusiasts! I have a question, which is no doubt due to some inexperience of my Delphi XE2 knowledge. I'll try to explain it here. Introduction: I have an Interbase database with data. This database is located on a remote machine. The…
RvdV79
  • 1,912
  • 15
  • 34
6
votes
3 answers

Which version of Interbase or Firebird was a database created under?

I have a file with an extension .ib. I am guessing it is either an Interbase or a Firebird file, but I am having trouble working out exactly which. Furthermore, it isn't clear exactly which version of Interbase (or Firebird) was used to create the…
awmross
  • 3,639
  • 3
  • 34
  • 47
6
votes
3 answers

Firebird 2.5 VS Interbase 9/XE - which performing faster?

We are on a situation where we must choose between thoose 2 databases. We are currently on Firebird, but sometime it lag because of it stacking too much transaction history or something and backup-restore shall be applied in order to make things…
Yordan Yanakiev
  • 2,366
  • 3
  • 35
  • 82
6
votes
1 answer

Define variable and run a query using EXECUTE BLOCK

I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do: SELECT * FROM customers WHERE customerid = 1234; I want to define 1234 as a variable, say customerID,…
Valentin Despa
  • 34,200
  • 18
  • 76
  • 100
6
votes
1 answer

How can I access an Interbase (.IB) database using RubyOnRails?

I have a database in Interbase and I want to access it directly from my Rails app using ActiveRecord. How can I do it?
Daniel Cukier
  • 10,639
  • 12
  • 61
  • 115
6
votes
2 answers

How do I limit the number of records returned for Interbase 7.1?

We have an Interbase 7.1 database and I'm trying to figure out how to limit the number of records returned by the query to just 1. I really only need to know an event code from the last record, in which the query will return hundreds of records if…
Dragn1821
  • 777
  • 2
  • 7
  • 19
5
votes
2 answers

How to speed up Count(*) in Interbase/Firebird

Interbase is a generational database. That's great because rollbacks are near instantaneous, but count(*) takes forever. This is unlike e.g. MySQL where count can use an index. I never knew why until I saw this: Even when an index is available…
Johan
  • 71,222
  • 23
  • 174
  • 298
5
votes
1 answer

Opening .gdb database files

I'm trying to open an old interbase .gdb file. This is a new step for me and i don't know where to start any advice would be a great help, I've been searching the internet for the past few days now and i still have to idea how to do so.
Leo Elvin Lee
  • 169
  • 1
  • 5
  • 16
5
votes
4 answers

Best way to connect to Interbase 7.1 using .NET C#

Could someone please explain the best way to connect to an Interbase 7.1 database using .NET/C#? The application will be installed on many end user computers so the less "add-ons" that I will have to package with my application the better.
Jonathan
1
2 3
…
22 23