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

InterBase: How to create view with a multible tables?

I am using SQL statement to create a view, but all the time I have problems with syntax. The four tables I have are: CREATE TABLE "BOOK_ORDER" ( "ID" INTEGER NOT NULL, "Open_Date" DATE NOT NULL, "Close_Date" DATE, "Student_ID" INTEGER…
KAMAEL
  • 175
  • 2
  • 16
0
votes
1 answer

Interbase SQL taking long time to execute

I am trying to figure out why a SQL statement execution is taking such a long time. It is going against two tables and both are of significant size but not big enough to warrant any delay. It is: Select pm.Type From History ah inner join…
Rick cf
  • 134
  • 12
0
votes
0 answers

InterBase database blob column

Could anyone please tell me how can I display the contents of an InterBase database blob column. I am trying to display the column in plain text or display its content but cast doesn't convert the data type. BLOB SUB_TYPE 0 SEGMENT SIZE 80
Pu99etMaster
  • 1
  • 1
0
votes
1 answer

how to connect UNC-located database to embedded server?

I have next specific situation. I have an application using Firebird embedded server. The files: application executive, database, fbembed.dll are located in the same folder. Everything is good and working good. Now my client says so: I would like…
mad
  • 1,029
  • 3
  • 17
  • 38
0
votes
2 answers

How can you group by the result of a case if case is not supported in the group by clause in intebase

I have tried using the columns alias, column number, using the case statement in the group by with no luck. Is this a shortcoming of interbase? select case when vp.preferredvendor = 'Y' then vp.name else 'Misc' end as vendor, …
wizhippo
  • 78
  • 1
  • 5
0
votes
1 answer

Union query with literals in InterBase

I have just started using Interbase and I am trying to run the simple query. When I have 'SEQUENCE' (or 'INDEX' or 'something') in BOTH part of union query it works fine, but when I have different strings in two parts of the query it produces an…
user306080
  • 1,409
  • 3
  • 16
  • 37
0
votes
1 answer

Errors when trying to migrate my InterBase .gdb from version 6 to Xe3

I prepared the databases in InterBase 6 and now want to migrate them to InterBase Xe3 but I keep getting the following error: Error Connecting to requested database message length error (encountered 287, expected 68) Any ideas about what might me…
Allan Fernandes
  • 121
  • 2
  • 13
0
votes
1 answer

IBQuery insert - Column unknown / Unsupported feature

Im trying to insert a row into a firebird database (embedded), but geting an exception when calling: datamodule1.IBQuery1.prepare Project xyz.exe raised exception class EIBInterBaseError with message 'Dynamic SQL Error SQL error code = -206…
john_who_is_doe
  • 389
  • 3
  • 18
0
votes
2 answers

Interbase SQL statement using MAX as filter?

Is it possible to use a max statement to subselect certain rows from a query on the MAX of one column? I tried several things that did not work. I tried the max statement. I also see that maybe Interbase does not support what I commonly do in SQL…
Rick cf
  • 134
  • 12
0
votes
1 answer

ibase_fetch_assoc: Fatal error: Maximum execution time of 30 seconds exceeded

I created this code to get an Interbase database, the total sales of a particular day:
JuJoGuAl
  • 117
  • 1
  • 15
0
votes
4 answers

Optimize SQL with Interbase

I was inspired by the good answers from my previous question about SQL. Now this SQL is run on a DB with Interbase 2009. It is about 21 GB in size. SELECT DistanceAsMeters, AddrDistance.Bold_Id, AddrDistance.Created, AddressFrom.CityName_CO as…
Roland Bengtsson
  • 5,058
  • 9
  • 58
  • 99
0
votes
1 answer

Interbase XE3 Developer Edition doesn't save data

First I tried to execute simple INSERT request using IBX and FIBPlus, the query worked out but I couldn't find the record in the database. Then I made the same request using IBExpert executed request showed in the grid but after I reconnected to the…
user287161
0
votes
1 answer

interbase error in select statement

Dear all I got error from my php: PHP Warning: ibase_query(): Dynamic SQL Error expression evaluation not supported Strings cannot be added or subtracted in dialect 3 in /home/jeinqa/www/oqc/getsch.php on line 22 come from my script…
nunu
  • 2,703
  • 9
  • 33
  • 55
0
votes
1 answer

Backup an encrypted database with gbak

I want to backup my encrypted database (database level not column level) with this command: gbak myDb.IB myDb.bak -b -user sysdba -pass masterkey -encrypt mySep -sep myseppass -service service_mgr But it doesn't work. Here is the error message:…
yush
  • 1
  • 3
0
votes
1 answer

InterBase database file appears corrupt ()

I am getting this error when I try to delete some rows in InterBase database, but for those ROWS I can fire SQL queries for SELECT and also UPDATE ... but not delete. What went wrong , what is the possible solution.
Posto
  • 7,362
  • 7
  • 44
  • 61
1 2 3
…
23 24