Stack Overflow
Stack Overflow

Questions tagged [firebird1.5]

For questions specific to Firebird 1.5. It is advisable to also tag with firebird.

Firebird 1.5 is a - now discontinued - version of the Firebird database server.

Resources

See also

54 questions
6
votes
3 answers

Updating generator value issue

I'm currently working on modifying a Firebird v. 1.5 database. The database structure will be modified running queries from a delphi application using interbase components, the problem I'm facing is that I need to run a lot of queries, some of which…
user497849
5
votes
4 answers

Cannot change sysdba password with Gsec

I have firebird 1.5 super server installed on my windows 7 machine. I am unable to use the Gsec utility to change the sysdba password for the default user. The firebird service is running and I verified this several times. When running gsec from a…
Matt
  • 1,168
  • 2
  • 15
  • 24
5
votes
3 answers

My Delphi 7 with Firebird 1.5.6 application is freezing itself after some time of inactivity on Windows 7

I have developed a Delphi 7 application that is using Firebird 1.5.6 database in client server environment. The application is running on Windows 7 32 bit on notebook computer an the database is running on Windows XP 32-bit machine that is used as…
Patrik
  • 1,286
  • 1
  • 31
  • 64
5
votes
2 answers

Error SQLCODE -904 in firebird after installation

I installed firebird database for the first time in my life (version 1.5.6 on Windows 7), after installation I can not connect to the sample database (employee.fdb exists), or create a database. This gives the following error in ISQL…
Bartłomiej Pach
  • 241
  • 1
  • 7
  • 13
4
votes
0 answers

"No current record for fetch operation" for select insert

Can anyone see why I'm getting the "No current record for fetch operation" below? I'm successfully skipping duplicate records by catching and not re-throwing the unique key violation exception below. There is another error however. FOR SELECT …
jcalfee314
  • 4,642
  • 8
  • 43
  • 75
3
votes
1 answer

List only unique users

Table is users, columns are user_id, firstname, lastname, area. The other table is user_sessions, and columns are user_id, logon, logoff. To see who is logged on I use select u.FIRSTNAME, u.LASTNAME, u.PHONE_ID, us.LOGON from USERS u join…
L_GIB
  • 125
  • 7
3
votes
2 answers

Field name from ID on table 1 but name on other table

This is a Firebird database. First Table Contacts Company_ID - job_title Second Table Client_id - Co_name In contacts, I want to the job_title field to contain the co_name. client_id and company_id are the same. Co_name correspond to company_id as…
L_GIB
  • 125
  • 7
3
votes
1 answer

Delphi 7 updating joined tables

I'm working with Delphi 7 and Firebird database. I'm using TIBDatabase, TIBTransaction, TIBQuery, TIBDataSet and DBGrid to establish connection and provide user interface for working with table. In my database I have two tables: Ships fields Id…
StableUpper
  • 153
  • 1
  • 1
  • 8
3
votes
1 answer

Firebird database keeps getting larger

This one is interesting to me - despite the almost inane title. I have used Firebird for a long time, but not until recently noticed an interesting behavior. I am using embedded Firebird 1.5, and noticed that if I stuff the database full of blobs…
Liam
  • 83
  • 6
2
votes
3 answers

How to drop all triggers in a Firebird 1.5 database

For debug purposes I need to send 1 table of an existing Firebird 1.5 database to someone. In stead of sending the whole db , I want to send just the db with just this table - no triggers, no constraints. I can't copy the data to another db because…
Edelcom
  • 5,038
  • 8
  • 44
  • 61
2
votes
1 answer

PHP + Delphi + FireBird

I have a problem to retrieve large volume of data with PHP + Delphi 9 + Firebird. Application screen shot I have a button in Delphi Application called "checks" , when I click the button it generate PHP Excel File by retrieving data from Firebird…
user3885256
2
votes
2 answers

List active statements on firebird 1.5

How to get the current number of active transactions/statements in firebird 1.5? I know after 2.1 there is a MON$STATEMENTS table which holds the current active transactions, but only after version 2.1, does anybody know if there is a way of knowing…
Mateus Viccari
  • 7,389
  • 14
  • 65
  • 101
2
votes
1 answer

firebirdsql psql accessing exception string

Upon trapping an exception in PSQL, is there anyway to access the exception number or string? In this block, you have the SQLCODE or the GDSCODE, but where is the exception string?
jcalfee314
  • 4,642
  • 8
  • 43
  • 75
2
votes
0 answers

Stop Firebird modifying strings based upon Windows charset

I have an application (written in Delphi) using the 1.5.5 Firebird embedded engine. I am using this engine since the application works with currently deployed Firebird databases and newer embedded engines won't open the database files correctly (ODS…
Ritsaert Hornstra
  • 5,013
  • 1
  • 33
  • 51
2
votes
2 answers

Grails: Building an Application for an existing Database. How to generate fitting Domainclasses

i got an old Firebird Database with a lot of content. Is there an easy way to get the content of this Database without rewriting the tables from Database for an Grails Application? An example would be nice. Thank you!
bastianneu
  • 2,059
  • 2
  • 18
  • 31
1
2 3 4