Stack Overflow
Stack Overflow

Questions tagged [flamerobin]

FlameRobin is a database administration tool for Firebird RDBMS

32 questions
4
votes
3 answers

Flamerobin connection failed with Firebird 3.0 in Ubuntu 16.04 LTS - Error: connection rejected by remote interface

I just installed Firebird 3.0 in Ubuntu 16.04 LTS. I can connect to the server with Flamerobin from a Windows computer. I also installed Flamerobin in the server to be able to manage the databases locally, but after to register the server and…
AngelAvila
  • 418
  • 5
  • 14
3
votes
1 answer

Tokene unknown creating a stored procedure with dynamic table name

I try to check existence of a record before inserting into table. SET TERM ^ ; CREATE PROCEDURE add_videorecord(tab_name varchar(31), col_name varchar(31), col_value varchar(100)) RETURNS (status int) AS BEGIN status=1; if (not exists( select *…
Abigor31
  • 47
  • 6
2
votes
1 answer

Why does Firebird 2.5.8 return NONE on SELECT CURRENT_ROLE?

Following on from my question here How to REVOKE ROLE GRANTED BY another user on Firebird 2.5.8? and @Arioch's helpful suggestion to query what ROLE is actually connected prior to the command. SELECT CURRENT_ROLE FROM RDB$DATABASE Now despite my…
David Carr
  • 402
  • 4
  • 7
2
votes
2 answers

How to select dates with same day and month (ignoring year) using firebird

I have a database where users stores their birthday. y-m-d, and I'm trying to get every user that has the same birthday; the year can be different between each user. So how do I turn this to a working script: SELECT username FROM table_name WHERE…
user3505049
  • 139
  • 2
  • 3
  • 11
2
votes
3 answers

How to find which table column corresponds to a constraint in a Firebird database?

I have a legacy Firebird (Version 2.5.2) database and am using FlameRobin (Version 0.0.2.1851) to inspect it. I have run the following query on the RDB$RELATION_CONSTRAINTS table to search for the constraint named 'INTEG_172': SELECT * FROM…
prajna
  • 1,579
  • 1
  • 15
  • 18
2
votes
2 answers

Firebird: Why does ALTER TRIGGER have no effect on other sessions/connections?

When I modify a trigger using the FlameRobin SQL editor, the changes have no impact on other sessions/connections: the trigger is still executing the old version. How is this possible? How can I force the changes to affect all connections? I do call…
Lapio
  • 21
  • 2
1
vote
0 answers

Flamerobin doesn't connect to Firebird database (msg: -902 isc_attach_database failed)

I'm studying Firebird 2.5 with FlameRobin 0.9, installed on a VM Virtualbox (with O.S. Win7 32bit PRO). The .fdb files are on the same disk of the Firebird machine and the FlameRobin program. The machine is not embedded and run as Superserver. With…
Antonio Bianca
  • 11
  • 7
1
vote
1 answer

Fill Firebird column with incremental data using Flame Robin

I have a huge Firebird database with a table that counts 41 millions of rows. Recently I have added a new float column and would like to fill it with incremental data. Each next value should be a previous incremented by RAND(). The very first value…
Paul
  • 23,702
  • 36
  • 106
  • 215
1
vote
1 answer

Firebird statements no error but no result

Running Firebird on my Raspberry Pi at the moment and using FlameRobin to control it. With another Raspberry Pi I want to some statements to it, I don't get any error codes but the data just doesn't get there. import RPi.GPIO as GPIO import…
Ynias Reynders
  • 199
  • 11
1
vote
2 answers

UPDATE or INSERT INTO is not working in procedure?

Table Attendance: EMPL_KODE |EMPL_NAME |DATE_IN |TIME_IN |TIME_OUT|TOTAL_MIN |TOTAL_HOUR -------------------------------------------------------------------------- 001 | Michel |25.04.2016 |06:50 |15:40 |NULL |NULL 002 |…
Andiastika Intan Pratiwi Hasan
  • 79
  • 11
1
vote
1 answer

Can't make view from multiple table

I'm trying to learn about view in SQL. In my case, i can't execute statement to create view. Here is the statement: CREATE VIEW VTOTALMINUTESEMPLOYEE (EMPL_KODE, EMPL_NAME,DATE_IN, TIME_IN, TIME_OUT, HASIL) SELECT EMPLOYEE.EMPL_KODE, …
Andiastika Intan Pratiwi Hasan
  • 79
  • 11
1
vote
1 answer

Firebird Error in Creating Trigger

Preparing query: CREATE TRIGGER autoincrementor_id FOR ID ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.OID IS NULL) THEN NEW.OID = GEN_ID(MY_GEN_ID,1) Error: *** IBPP::SQLException *** Context:…
alyssaeliyah
  • 1,684
  • 3
  • 24
  • 62
1
vote
3 answers

Simple Firebird Query

I am trying to do a while loop in Firebird to execute all the values from an SP using FlameRobin tool. However this is not working. Any suggestion? declare i int = 0; while ( i <= 2 ) do BEGIN SELECT p.SOD_AUTO_KEY, p.CURRENCY_CODE,…
user3314399
  • 307
  • 3
  • 9
  • 22
0
votes
1 answer

How to create PSQL stored functions via flamerobin

I have installed flamerobin admin tool 0.9.2 with Firebird 3. Is there any straightforward way to create PSQL stored functions via flamerobin and how? That would help me a lot!
asimkon
  • 867
  • 1
  • 13
  • 17
0
votes
1 answer

How to modify a database which can be only access with FlameRobin in phpmyadmin/MySQL Workbench

How to modify a database which can be only access with FlameRobin in phpmyadmin or in MySQL Workbench eg. I can access the database in FlameRobin. but when I try to access the DB in phpmyadmin It takes awhile to load then mysqli::real_connect():…
Bamuel
  • 55
  • 8
1
2 3