Stack Overflow
Stack Overflow

Questions tagged [ibexpert]

40 questions
12
votes
2 answers

Oracle SQL Developer, how to open table/view by clicking/double clicking on its name in worksheet?

The Oracle SQL developer is what I use these days and it is missing some of my previous tool (IB Expert, great tool by the way) functionalities. 1.How is it posible in SQL Developer to open table/view by click/double click on its name in the…
Ali
  • 899
  • 2
  • 13
  • 33
3
votes
1 answer

Can I programmatically exit a Firebird script

Consider the following script: set term ^; exit ^ execute block as begin execute statement 'this will fail'; end ^ The exit is perfectly valid and does cause script execution to end. At least in IBExpert where I am testing this. But I want to…
Paul
  • 5,700
  • 5
  • 43
  • 67
3
votes
2 answers

Firebird2.5 Error: "duplicate value in unique index" without duplicate data

Hello and thanks for reading and probably also helping me brief explanation of my problem: I am copying Data from one Firebird-Database to another (called V14) and i am using IBExpert to do so. The tables are named equally and have the same…
user3327902
  • 31
  • 1
  • 2
3
votes
3 answers

Export Firebird database to sql

I have several databases in Firebird using IBExpert as the GUI admin. I am changing over to MySQL. I can use IBExpert to backup the database (which gives me the full structure and data) but the gbak format can't be read by phpMyAdmin. PhpMyAdmin has…
Frank Luke
  • 1,342
  • 3
  • 18
  • 33
2
votes
1 answer

IBExpert insert into with column value given by variable

Within IBExpert I'm looping over Dates within a "Master Procedure" and try to set the currently looped date as value within the "Date" Column of the Table I'm inserting into. The Table I'm inserting into is very simple: Table Name:…
sHooP
  • 173
  • 1
  • 8
2
votes
1 answer

How to use a generator in my execute statement in a stored procedure?

I'm trying to create a simple stored procedure in IBExpert for a Firebird 2.5 database. I'm having trouble to work with generators though. I think I've created a valid generator & trigger. But I don't know how to apply those in my execute…
sHooP
  • 173
  • 1
  • 8
2
votes
1 answer

Cannot connect Firebird in IBexpert

I have installed Firebird 3.0.2 (x64) and IBExpert 2018.12.15.1. I'm trying to create a Firebird DB on IBExpert but everytime getting this error: Unsuccessful execution caused by system error that does not preclude successful execution of…
Igor Tenório
  • 161
  • 1
  • 2
  • 14
2
votes
2 answers

Output CSV file with trigger in Firebird

Is it possible to create a trigger that outputs a CSV file selecting Fields 1 from Table 1 right after Table 2 is updated? I have tried using CREATE OR ALTER trigger test_a0 for Table 2 active after insert or update position 0 AS begin if…
Alberto Montanez
  • 21
  • 2
2
votes
1 answer

Why are sql generators using double parenthesis in where clause?

I worked with different kind of auto generated sql statements like MS Access and Firebird sql. When I used some query builders to generate this sql snippets (Access or IBExpert) they often generate more parenthesis than needed. I don't think about…
Booser
  • 576
  • 2
  • 9
  • 25
1
vote
1 answer

Sql error while creating tables - Firebird

I have simple sql code for create table and then add constraint to it. It looks like this: CREATE TABLE bills ( id INTEGER NOT NULL, code VARCHAR2(25) NOT NULL, dateOfGeneration DATE NOT NULL, job_id …
Rocky3582
  • 573
  • 4
  • 7
  • 17
1
vote
1 answer

Firebird list domains and data types

I want to list all domains, their datatypes, and size. Background I've managed to do the query, based on this SO answer. The basic code takes all fields: SELECT * FROM rdb$fields I found that I could get fields from rdb$fields: filter fields…
Max Makhrov
  • 17,309
  • 5
  • 55
  • 81
1
vote
1 answer

Transaction in firebird 1.5

How to make transaction using IB Expert? I need a manual or something like begin transaction create table someTable(a int,b int) insert into someTable values(1,2) insert into someTable values(3,4) commit transaction but working in Firebird to see…
Artem
  • 11
  • 2
1
vote
2 answers

Why can't I execute this alter procedure firebird query?

The query is: SET TERM ^ ; ALTER PROCEDURE SALVARROTA ( datahora timestamp, distancia double precision, custo double precision, capacidadelivre double precision, capacidadetotal double precision, nome varchar(50), …
Haruki
  • 674
  • 1
  • 9
  • 24
1
vote
1 answer

Firebird database file copy can't be opened

I got some dummy database (i use firebird) file, I fill it with some data and when filling procedure is finished I copy it and save with new name. Using code below, by the way: void importdb_module::copyAndSaveDatabaseFile(){ QString…
DanilGholtsman
  • 2,354
  • 4
  • 38
  • 69
0
votes
5 answers

Error opening Interbase database with IBExpert

wrong or obsolete version. unsupported on-disk structure for file C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\DESKTOP\BD.IB; found 11.2, support 11.2 When I went to open an Interbase database with IBExpert, I found this message. I am using the Firebird…
Yuri
  • 1
  • 1
  • 5
1
2 3