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
0
votes
2 answers

Interbase 2009: complete removal?

Are there any tools for completely removing an Interbase 2009 SMP installation? I found an article describing how to remove IB6 (http://edn.embarcadero.com/article/28131), but I'm reluctant to delete anything in the registry according to a document…
conciliator
  • 5,834
  • 6
  • 38
  • 62
0
votes
1 answer

Interbase SQL SELECT query using CASE

I'm running the following query against a .gdb-file: SELECT CASE USERS.USERID WHEN 1 THEN 'God' ELSE 'Somebody else' END FROM USERS; However, running essentially the same query against a .ib-file, I get "Error at line 1 Dynamic SQL Error, SQL error…
conciliator
  • 5,834
  • 6
  • 38
  • 62
0
votes
1 answer

Excel: Passing Cell Value to VBA SQL Statement

I have searched forever and cannot find a solution that works. Most likely because of ignorance. The database that I am querying is Interbase so the SQL syntax might be different than what I'm used to. When I add the following line to my SQL…
John Dawyers
  • 65
  • 10
0
votes
2 answers

Data Direct ODBC for Interbase

Im trying to connect to an interBase database, using a program called Data Direct ODBC Driver for Interbase. When i open Query1 which has fields from Table1 and Table1 is already opened, after some seconds i receive this message: reserved error…
Hodroj
  • 11
  • 3
0
votes
1 answer

Connecting to an Interbase Database File via C#

All -- I am trying to export data from an Interbase Version 5 database file by using the following connection string: Provider=LCPI.IBProvider;Location=\"";User ID=******;Password=*****;ctype=win1251" I have downloaded and…
Mark Kram
  • 5,368
  • 7
  • 49
  • 68
0
votes
1 answer

case: multiple left joins order

I have a header table( VATLH ) i need to join to multiple tables, i need to join it to vatld, to count the number of data rows, and join it to vldocd to see if it the header is used in a Doc (DOCID) So i use 2 left joins SELECT VATLH.periode …
r_j
  • 1,288
  • 14
  • 33
0
votes
0 answers

Checking for non-null (or null) result set for Firebird with PHP5

So, I haven't used firebird for that long, but i'm writing a search engine for a database we have. There is a field that required you to ask for a reason the record was changed if you edit the record for some reason. If the user fails to input…
Fooldj
  • 153
  • 12
0
votes
1 answer

How can I add a InterBase JDBC connection pool in GlassFish V3?

Using: InterBase 2007, latest interclient.jar (8.1.8), GlassFish v3 b68. I try to configure the connection pool in the web admin console page "Edit Connection Pool" with these settings: Resource Type: javax.sql.DataSource Datasource Classname:…
mjn
  • 35,561
  • 24
  • 160
  • 351
0
votes
1 answer

combining different Aggregate functions with CASE

I want to combine different sums for different periods in a query i use the following query to get a sum. SELECT table1.BRS, Sum(CASE WHEN table2.DATUM BETWEEN :van1 AND :tot1 THEN (DBBASIS-CRBASIS) ELSE (0) END) FROM table1 INNER JOIN table2 ON…
r_j
  • 1,288
  • 14
  • 33
0
votes
2 answers

How can i join between two databases in Interbase?

I have two interbase databases, and i want to make join between. Long time ago i use MS-SQL database, and there i did that. How can i make similar in InterBase database? Thanks answer so much!
GodGirl
  • 17
  • 1
  • 3
0
votes
2 answers

Using Order by with create view or insert in Interbase

I'm having problems sorting data in interbase, my timestamp is in seperate columns of year,month,date, etc so I need to order in that order (though in this case it wouldn't work even to order by a single field). For some reason the ORDER command…
Hamish_Fernsby
  • 548
  • 6
  • 26
0
votes
1 answer

InterBase ToGo trial license does not work

(Interbase ToGo is an embedded version of the InterBase sql database.) I am doing a simple evaluation of InterBase ToGo by accessing it from a Windows 7 app. However, when I run my application I get a popup saying "product INTERBASE is not…
Grubl3r
  • 357
  • 1
  • 5
  • 18
0
votes
2 answers

Is there an efficient and free method of migrating a 6GB Interbase DB to MySql?

That's about it. I can always just dump it to csv and read it in, but I was hoping to avoid that.
user119282
  • 327
  • 4
  • 12
0
votes
1 answer

TDBMemo showing weird output

Using an Interbase database I have an application in which I want to show the contents of an memo field. I have created a datamodule on which I put a TIBDatabase, TIBTransaction, TDataSource and TIBTable all connected. Data comes out, no problems so…
Gerald Versluis
  • 21,913
  • 5
  • 52
  • 75
0
votes
1 answer

Interbase IBConfig setting for Server_Priority_Class

In the OpGuide on page 61: SERVER_PRIORITY_CLASS . Priority of the InterBase service on Windows server platforms . The value 1 is low priority, 2 is high priority . Relevant only on Windows server platforms . Default is 1 In the IBConfig file…
Tom Greenway
  • 1
  • 1
1 2 3
…
22 23