Stack Overflow
Stack Overflow

Questions tagged [ibexpert]

40 questions
0
votes
0 answers

IBExpert Database Designer Table Relationships

Assuming I have this 2 tables: I want to keep the address information in a sepparate table Address, because not always the person's address is known, therefore, in this case, there will not be a corresponding entry in the Address table for that…
user2383818
  • 709
  • 1
  • 8
  • 19
0
votes
1 answer

Cannot use IBExpert after updating to Firebird 4.0

IBExpert has a user database which stores all options. I made a FBK backup of this database using Firebird 2.5 which was my old level. I installed Firebird 4.0 and restored it. Now I have this database under both ODS levels (I believe that would be…
Paul
  • 5,700
  • 5
  • 43
  • 67
0
votes
2 answers

Database is in use - Cannot connect to the database with my application

I am using Firebird 4.0 with SuperServer installed on Microsoft Windows 2011. I am developing a win64 database application with Delphi to access the database file on a remote computer. If I connect to the database file with IBExpert while I also try…
IMeMine
  • 5
  • 3
0
votes
0 answers

IBExpert 2021.7.8.1 - Firebird 2.5 database compare stored procedure domain names commented out

I have IBExpert 2021.7.8.1 and Firebird 2.5 When I perform a database compare on stored procedures, my input and output parameters domain names are removed and replaced with the variable representative. On most occasions the domain is commented…
Yuppski
  • 137
  • 2
  • 10
0
votes
1 answer

How to print message in ISQL / IBExpert Sql tool?

I know that in SQL Server we can print message via operator PRINT, but PRINT doesn't work in IBExpert, and command OUTPUT too. Can someone help me? I have this error when I run previous code:
Nika
  • 379
  • 2
  • 16
0
votes
2 answers

INSERT INTO in IB Expert

I have thousands of lines that look like this: insert into TABLE (name) values ('name_1'); insert into TABLE (name) values ('name_2'); ... insert into TABLE (name) values ('name_10000'); Executing them one by one works just fine. But when I want to…
resharper
  • 1
  • 1
0
votes
1 answer

How to change the data type of a column if it is the primary key and is indexed?

I'm using IBExpert to operate my databases. I have an old table with two fields: - code (char 3) PK + INDEX - name (varchar 30) The new table should be - code (integer) PK + INDEX - name (varchar 30) The data in the code column consist of…
VirussInside
  • 187
  • 17
0
votes
0 answers

How can I export the images from my database?

I have to export images (blob) from my database (Firebird) using IBExpert, how can I do it?
Seertuuu
  • 1
0
votes
0 answers

How to change domain of a field in IBExpert?

I wanted to change a field from D_ALPHA2NOTNULL to D_ALPHA8NOTNULL, so that I am able to use more chars. Unfortunately if I am trying to change the domain I am getting an error message: action cancelled by trigger (2) to preserve data…
ebug38
  • 171
  • 1
  • 14
0
votes
2 answers

Is there a detailed debug feature in Firebird?

I wanted to debug an execution of a procedure. Behind this procedure there are several triggers and transactions. There is one dataset which is updated within this procedure which behaves different than all the other datasets. So I wanted to debug…
ebug38
  • 171
  • 1
  • 14
0
votes
2 answers

Is it possible to search for all dependencies of a field

I am searching for a specific line in my database and wanted to know if there is a function in ibexpert to look up for all dependencies of a field.
ebug38
  • 171
  • 1
  • 14
0
votes
0 answers

How to fix character bug in existing .db file

I'm trying to import a .db file into a existing database through a tools called 'Import Data' in IBExpert. I have a problem with the encoding of the .db file, when the import is done characters like 'ç, ã, õ' are not recognized. I've been trying to…
Vicenzo Martinelli
  • 29
  • 3
0
votes
1 answer

How to export blob data values with IBExpert/ IBEscript?

I want to export data from my database to a csv file using IBEscript for a Firebird database. Everything works fine just the columns with blob data don't work. they just miss within the csv file. When I run the same query in the IBexpert and export…
Tom77
  • 1
  • 1
0
votes
2 answers

SQL Multiple Rows in Singleton Select

I have the following SQL: WITH G1 AS (SELECT G.NUM_REFE, G.GUIA AS MASTER, (SELECT H.GUIA FROM SAAIO_GUIAS H WHERE G.NUM_REFE = H.NUM_REFE AND H.IDE_MH ="H" AND H.CONS_GUIA="1" ) AS HOUSE FROM SAAIO_GUIAS G WHERE G.IDE_MH ="M" AND…
Eduardo
  • 1
  • 1
  • 2
0
votes
0 answers

First commit slow with Firedac and Firebird

I'm coming here because I've exhausted my knowledge and search skills. I have a very simple application with Delphi XE2 and Firedac (Version 8.0.3) which uses TADQuery to insert a registry in a table that contains 800k rows (10 columns), primary key…
Rebelss
  • 364
  • 1
  • 5
  • 15
1
2
3