python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - firebird

Restore Firebird backup

I have a database backup of a Firebird. It has the .bak extension. I would like some help on how to restore this backup in IB Expert or DBeaver. Note: I always see IB Expert backup with GBAK, this is ...
test-img

Fernando

sql

firebird

restore

Votes: 0

Answers: 0

simplify simple query sql

Can someone help me simplify the following query into one line . SELECT LL_ID, LL_VOORNAAM, LB_VAN_VAN, LB_VAN_TOT, LB_VAN_ID, LB_VAN_INUIT_FK, LB_NAAR_INUIT_FK, iu_vorigeinuit...
test-img

Tonathiu Redrovan

sql

firebird

Votes: 0

Answers: 1

Latest Answer

This did it for me... ) AS LOOPBAAN_VAN ON ((IU_VORIGEINUIT_FK = LB_VAN_INUIT_FK) ) SELECT LL_ID, LL_VOORNAAM, LB_VAN_VAN, LB_VAN_TOT, LB_VAN_ID, LB_VAN_INUIT_FK, LB_NAAR_INUIT_F...
test-img

Tonathiu Redrovan

How do I select rows where elements of group have the same value?

I have a table like this: prop1 | prop2 aaa | xxx aaa | xxx bbb | yyy bbb | !yyy ccc | zzz ccc | zzz ddd | !kkk ddd | kkk and I want to be like: prop1 | prop2 bbb | yyy ...
test-img

Roberto palmer

sql

firebird

Votes: 0

Answers: 1

Latest Answer

If you want result of a select from the table to look like is written in your example, this may be the query: select * from t t1 where exists (select * from t t2 where t1.prop1 = t2.prop1 and t1...
test-img

user13964273

How to create trigger to take value from another table depends of value from first table

I'm lost with triggers in SQL Have one main table with all data, second table is only for support of first table. I need a trigger to get value from second table depends of value from first table. fir...
test-img

Novice

sql

triggers

firebird

Votes: 0

Answers: 2

Latest Answer

CREATE TRIGGER so_70683210 ACTIVE BEFORE UPDATE ON first_table POSITION 0 AS BEGIN SELECT category FROM second_table WHERE second_table.age = NEW.age INTO NEW.category; END
test-img

pilcrow

Posts

Questions

Blogs

Jobs