Re: [firebird-support] RE: Where I put firebird.msg on PC with two client?

2014-02-23 Thread Luigi Siciliano
Hallo, Il 22/02/2014 22.41, hv...@users.sourceforge.net ha scritto: Sounds crazy, sorry. Can you provide a reason for it ? Just curious... I have a component thath not works on unicode :-( Sure. You can a) run your application using bat\cmd file with two lines SET FIREBIRD_MSG=

[firebird-support] "lock time-out on wait transaction" when trying to DropDatabase

2014-02-23 Thread idan37s
Hi, I get an exception "lock time-out on wait transaction.. object aaa.FDB is in use" when i try to drop the table using "FbConnection.DropDatabase(ConnectionString)". It doesn't happen all the time, only when I access the DB a lot. I closed all the connections before dropping the table ('Conne

Re: [firebird-support] Trigger not working

2014-02-23 Thread Dmitry Kuzmenko
Hello, Werner! Saturday, February 22, 2014, 9:31:19 PM, you wrote: W> I have the following trigger which doesn't work for me, i.e. the columns W> in winerackit are never updated by it. W> In my current test case the 'fk_winerackit_id' column is set to "Null", W> so I would expect this trigger to

Odp: [firebird-support] Trigger not working

2014-02-23 Thread liviusliv...@poczta.onet.pl
Hi, To debbug trigger use log table in autonomous transaction context avaiable in fb2.5 or use external table which is outside of transaction management Regards, Karol Bieniaszewski - Reply message - Od: "Werner" Do: "firebird-support@yahoogroups.com" Temat: [firebird-support] Trigger

Re: [firebird-support] Trigger not working

2014-02-23 Thread Werner
Hi, Did a bit of googling and found the trick of putting in an exception and I also changed it to try to write to a temp table. CREATE OR ALTER trigger bottag_biud0 for bottag active before insert or update or delete position 0 as declare variable oldid bigint; declare variable newid bigin