Thanks for feedback, I see the first thing need to do is fix the sysdba user
access, then maybe looking at other methods..
Different things have been discussed. Just another view on your question(s):
1) Get rid of SYSDBA being the database owner. Send me an email if you
want to get a hand on
Is firebird embed working On Android or Iphone?
Trond wrote:
If you use Firebird version = 2.1 you can use something like this:
SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP,
ma.MON$REMOTE_PROCESS,
ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role,
ma.mon$state,
ma.mon$stat_id,
On Sun, 15 Jan 2012 20:37:37 -, richwiz11
richard.cro...@wizbang.co.nz wrote:
Hi, I need a way of logging or protecting data from being deleted by a
user.
I work for a POS (point of sale) company, each user shop would have a
local firebird db running. We are entering into a new market
Hi Homer, nice to hear from you again, I have not try it now but I'm pretty
sure I have done this in the pass. It depends on the way IBDac deals with
variants and timestamp because you are using an implicit casting. In that case
you should use encodedatetime or encodetime, you can find it in
Nick Upson
On 14 January 2012 14:39, Nick Upson n...@telensa.com wrote:
Hi,
using 2.1.4 (epel) on centos 5.5, We had a firebird crash with this
message:
Fatal lock manager error: invalid lock id (0), errno: 4
The system was under heavy load and it happened just after nbackup level 2
I don't get the point, sorry. If you perform SELECT in the same
transaction as INSERT, then neither SELECT WITH LOCK nor UPDATE should
wait. If the transactions are different, then both should wait. In this
latter case, SELECT WITH LOCK will not wait only if you have already
updated the
16.01.2012 18:42, Nick Upson wrote:
I've just found http://tracker.firebirdsql.org/browse/CORE-2630
which leads to http://tracker.firebirdsql.org/browse/CORE-2993 which says
its fixed in 2.1.4
They're unrelated, I believe. And once again, I suggest you to avoid
using nbackup.
Dmitry
hello!! I have this situation, and don't know how to solve it...
My table:
ID ORIGINAL_ID
1NULL
21
32
4NULL
51
So, the ID 1 has two children (2 and 5) and 2 has one children (3). Of
course, ID 3 could have N children and so
If you are using Firebird 2.1 or later, then the easiest way is to use a
recursive common table expression. I hope I got it right, but I think
you get the idea:
with recursive r(id, original_id, hierarchy) as (
select
id
, original_id
, 1 as hierarchy
from region
Or is there any plan for that?
--- In firebird-support@yahoogroups.com, Ahmet Nuri D ahmetdenize@... wrote:
Is firebird embed working On Android or Iphone?
11 matches
Mail list logo