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.

356 questions
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
  • 36,362
  • 28
  • 176
  • 378
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,348
  • 15
  • 35
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
  • 558
  • 1
  • 7
  • 28
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
  • 417
  • 1
  • 7
  • 19
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
  • 337
  • 4
  • 12
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
0
votes
2 answers

How to hide stored procedures and triggers code from users other than SYSDBA in Interbase?

I found some information about the encryption and embedded password features in Interbase 2009, but it does not prevent database users to see the source code. Is it possible to hide the stored procedures and triggers codes from all user including…
Colin Jong
  • 63
  • 1
  • 6
0
votes
1 answer

Remove white space between words in interbase

I need to remove all white space between "words" in interbase. Coming from a SQL server background I was assuming (wrongly) that interbase would support a replace function but aparently doesn't. So given a telephone number that may or may not…
Rich Andrews
  • 4,168
  • 3
  • 35
  • 48
0
votes
2 answers

Correct use of alias in Interbase subqueries

I have a problem with my newly created aliases ABONO and CARGO. The ALIASES (for the column names of the result) and SQL query works fine UNTIL I try to calculate "ABONO-CARGO AS AJUSTE" => Interbase gives an error that it does not know the column…
Florian Wagner
  • 31
  • 2
  • 8
0
votes
1 answer

Loading large firebird datafile table into a DataSet

I have a Firbird 1.0 data file weighting aprox 25 GB that I am working with it. It has a table which has stored documents and doc's pics as blob. So, I am asking is it possible to open such big data file using fib datasets, i firstly tried to open…
Suhrob Samiev
  • 1,528
  • 1
  • 25
  • 57
0
votes
1 answer

Deploying Interbase ToGo on Mac OS X

Here are the conditions for the experiment: Interbase ToGo is licensed Interbase folder including the license folder is in the same folder as my multi-platform application called myPgm.app developed by Delphi XE2 as HD-FMX application. When…
user1311715
  • 1
  • 1
-1
votes
1 answer

Unable to log into Local Server -gds_db InterBase Developer Edition

Unable to log into Local Server -gds_db after download of Interbase Developer Edition. Getting "Error logging into the requested server" Connection rejected by remote interface' .Using un/pw of SYSDBA masterkey.
Richard King
  • 1
-1
votes
1 answer

Some columns returned empty from interbase sql

I have strange problem on my pc/server. I run query such as Select field1, fieldId from myTable this will return in average 10 results Now the strange thing: sometimes when i render it to my drop down list, the fieldId is blank, i mean rendered…
cpoDesign
  • 8,953
  • 13
  • 62
  • 106
-1
votes
1 answer

Search Interbase with php form (drop down list with values of one column)

I am trying to make a search form (which will be best to be with drop down menu) with values from column CUST_BULSTAT and to fetch a single row data that will be printed into a text template document. On this stage I am connecting to database and…
Ombre
  • 1
1 2 3
…
23
24