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
3
votes
1 answer

Alternative to RDB$GET_CONTEXT and RDB$SET_CONTEXT

I need to convert SQL statements RDB$GET_CONTEXT and RDB$SET_CONTEXT from Firebird to Interbase so what I should use ? Here is the complete Firebird SQL: if (rdb$get_context('USER_TRANSACTION', 'Lock_Trigger') = '1') then exit;
William
  • 3,692
  • 10
  • 50
  • 101
3
votes
2 answers

SQL conversion error / how to insert parameter into select statement?

I'm running an IB database interfacing through FireDAC. The following dynamic query works : INSERT INTO RELATIONS (C_ID, M_ID, A_ID) SELECT c.C_ID, 0, a.A_ID FROM CATEGORIES c, ACTIONS a WHERE c.NAME = :CATEGORY AND a.NAME = :ACTION I add a column…
Peter
  • 2,869
  • 1
  • 14
  • 27
3
votes
1 answer

Wildcard as parameter of stored procedure

Suppose, I have a stored procedure, that accepts one parameter - id, and returns some data corresponding to this id. What if I want to retrieve all such data, like using wildcard in SELECT query? How to do this?
Andrew Vershinin
  • 137
  • 2
  • 3
  • 10
3
votes
1 answer

Visual Studio Borland dll error

hen I run the application within Visual Studio 2012, it works like a charm, but when I try to run the .exe file in the bin folder, I get this error: System.IO.FileLoadException: Could not load file or assembly 'Borland.Data.DbxCommonDriver,…
Docschnitzel
  • 165
  • 1
  • 2
  • 12
3
votes
1 answer

How to limit number of records in Dynamic SQL

I want to execute a SELECT query which would return limited number of records in Dynamic SQL for Firebird database server. similar to the one in SQL of MSSQL SELECT TOP 10 * FROM table; P.S., i am using interbase 6.0 database with firebird 2.5…
rutulPatel
  • 312
  • 4
  • 12
3
votes
2 answers

One active IB transaction the whole lifetime of a single user application

Are there any negative impacts when a single user application uses only one IB transaction, which is active as long the program runs? By using only CommitRetaining and RollbackRetaining. Background: I want to use IBQuery(s) and connect them to a DB…
markus_ja
  • 2,841
  • 2
  • 23
  • 36
3
votes
1 answer

Opening Firebird database (8.15)

I'm close to the end of my tether with this so any help would be gratefully received! Trying to connect with Interbase "IBConsole" and I get the following message: "Unsupported on-disk structure for file C:\TEMP\SYSTEM.GDB; found 8, support…
fritterfatboy
  • 337
  • 1
  • 10
3
votes
2 answers

Interbase / Firebird equivalent for mysql_num_rows()

I'm looking for an efficient way to retrieve a count of the number of rows returned a result set from an Interbase / Firebird DB. The closest equivalent (but unusable) function that I've found is mysql_num_rows() Any suggestions?
AU_Outpost
  • 205
  • 1
  • 3
  • 15
3
votes
3 answers

Database Design: Alternate to composite keys?

I am building a database system and having trouble with the design of one of my tables. In this system there is a users table, an object table, an item table and cost table. A unique record in the cost table is determine by the user, object, item…
kgrad
  • 4,462
  • 7
  • 33
  • 57
3
votes
2 answers

Interbase transaction monitoring

I have a very strange problem with transactions in Interbase 7.5 which seem to be stuck. I can track the problem with IBConsole -> right click DB -> Performance Monitor -> Transactions Usually this list should show only a few active transaction. But…
fuchs777
  • 936
  • 1
  • 13
  • 26
3
votes
1 answer

Firebird install conflict with Interbase

Are there conflicts created if Firebird is installed to a system that already has Interbase installed. I see some mention of using the same Ports, additions to the Path, and a common program name in ISQL.exe as the command processor. I see…
Patrick Moloney
  • 632
  • 5
  • 14
3
votes
4 answers

How to convert legacy Interbase DB to SQL Server?

I have an Interbase DB. How can I convert it to SQL Server?
Mariano
  • 2,758
  • 6
  • 23
  • 28
2
votes
1 answer

EIBInterBaseError 'unavailable database' when trying to create a Firebird database in Delphi

I'm trying to create a Firebird database during runtime. The procedure that I'm using to do this is this one: procedure CreateDatabase(DBName: String); var IBDatabase1: TIBDatabase; begin IBDatabase1 := TIBDatabase.Create(Self); try …
ivarec
  • 2,414
  • 2
  • 28
  • 50
2
votes
1 answer

Unable to detect the correct character-encoding

I need to extract data from some old interbase databasefiles created with InterBase 4.2.1. I'm using the embedded version of Firebird (version 2.5.1) and the .NetProvider (version 2.7.0). I never worked with interbase of firebird before (but i have…
Marc
  • 863
  • 2
  • 10
  • 28
2
votes
3 answers

help with PHP and interbase

im trying to create a PHP web application to connec to an interbase database. Iv installed xampp for the PHP and Apache. I then installed Firebird SQL 2.5 to get the required DLL's. however iv noticed that in the php\ext folder there doesnt seem to…
c11ada
  • 4,182
  • 14
  • 43
  • 62
1 2
3
…
22 23