FlameRobin is a database administration tool for Firebird RDBMS
Questions tagged [flamerobin]
31 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
- 427
- 5
- 15
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
- 7
2
votes
1 answer
Does FlameRobin have problems with the insertion of umlauts?
I have a table with a field
VALCONTENT BLOB SUB_TYPE TEXT SEGMENT SIZE 80
When I browse the table, right click on an entry, select "Edit blob" the content is shown.
If I enter "normal" test ("Hello world"), I can click "Save" and things work.
If I…
ralfiii
- 584
- 4
- 13
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
- 400
- 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
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
1 answer
Firebird permission denied when connecing with FlameRobin but is okay with isql
I'm trying to connect to employee.fdb in Firebird3.0 (localhost) using FlameRobin 0.9.3 on a Ubuntu OS.
The connection to Firebird using isql has no issues. I can create users, roles, etc all from the terminal. However, when I attempt to make a…
DanZ
- 451
- 2
- 9
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
- 2
- 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
- 25,812
- 38
- 124
- 247
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
- 309
- 1
- 14
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 |…
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,
…
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
- 2,214
- 6
- 33
- 80
1
vote
4 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
- 317
- 4
- 9
- 23
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
- 915
- 1
- 14
- 21