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 add guid field to existing table

I have an old existing interbase table and I want to add a primary key field to and populate it. Is there any way to do it all in the SQL statement (like SQL server). Example: ALTER TABLE IBUSERS ADD IBUSERSPK VARCHAR(32) default (newid()) NOT…
Rick cf
  • 134
  • 12
0
votes
1 answer

Radstudio and Interbase license issue?

I had my RadStudio setup all working and have created a very simple mobile app for android that uses IBLite to grab some data. For business reasons I had to leave the project and move on to other things. So I come back to Radstudio thinking I can…
Dave Gill
  • 234
  • 1
  • 14
0
votes
1 answer

Is a Transaction active when a IBQuery component is active

When opening a TIBQuery (IBQuery.Open), is the correspondig Transaction active only the time the data is fetched from the DB or as long as IBQuery is closed?
markus_ja
  • 2,931
  • 2
  • 28
  • 36
0
votes
1 answer

.net InterBase FireBird SQL

I am using InterBase and FireBird SQL in C# .net Enviroment. I would Like to use Transaction Scope in my program. How to do that Effectively with InterBase-FireBird ? Any Idea ?
Posto
  • 7,362
  • 7
  • 44
  • 61
0
votes
1 answer

Multiple Rows in Singleton Select

Yesterday, an anomaly occurred in our legacy software that I've never seen before. It triggers the following error: multiple rows in singleton select At procedure 'POINTS_BALANCE' Here is the Stored Procedure CREATE PROCEDURE POINTS_BALANCE ( …
AU_Outpost
  • 205
  • 1
  • 5
  • 15
0
votes
1 answer

Is it possible to run Interbase 2007 server with a windows user with restricted access?

I'm working on a legacy software and sundenly it became a requirement to run interbase server (Interbase 2007) logged with a restricted user. We tried this here (not me) but no client is able to connect to the server, including IBConsole, like no…
Rafael Romão
  • 1,788
  • 3
  • 20
  • 35
0
votes
0 answers

Data shows in BIDS preview but won't load when running

Fairly new to SSIS and having a problem with one table on my raw and history loads. Loading from an interbase table to a SQL server 2008 R2 via SSIS. In BIDS I can preview the table and it shows data, but when I run the data flow task nothing loads…
bvankampen
  • 315
  • 1
  • 3
  • 6
0
votes
0 answers

I/O Error for file database.gdb. No such file or directory, but that's not the file I'm trying to open

I'm trying to create a connection to an Interbase ToGo database, at runtime, in a unit that does not have a form. MyConnection := TSQLConnection.Create(nil); strTestPath := TPath.Combine(TPath.GetDocumentsPath,…
JFish
  • 61
  • 2
  • 5
0
votes
0 answers

How to localize (translate) exception message in Firebird/Interbase?

is there any chance to translate Interbase/Firebird exception messages ? For eg. I have Exception TOO_MANY_CONNECTS 'There are to many connect to database, please try again later.' And now clients from other country (for eg. Russia) want to see…
Marek Ruszczyk
  • 100
  • 1
  • 8
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
  • 6,078
  • 6
  • 41
  • 66
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
  • 6,078
  • 6
  • 41
  • 66
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
  • 1
  • 11
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,672
  • 7
  • 51
  • 70
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,348
  • 15
  • 35
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
  • 163
  • 1
  • 14
1 2 3
…
23 24