Re: AW: [firebird-support] difficult question

2013-12-05 Thread Iwan Cahyadi Sugeng
Hi, Are you having this problem when there are more than one user in transaction at the same time i'm guessing the problem is the child table have different parent key. Check in the child table wether the parent key is correct. The problem maybe because the child get a different parent key becaus

Re: AW: [firebird-support] difficult question

2013-12-05 Thread Tupy . . . nambá
Olaf, If you deliver us: -the create table of the involved tables (including all created keys, generators, a.s.o.); -some real data of the involved tables (specially for the cases when the problem happens); you will help people to help you. May be also the procedures involved in the data injecti

RE: [firebird-support] difficult question

2013-12-05 Thread Svein Erling Tysvær
>>>I have a table with orders and a second table with orderpositions. The >>>composite primary key from orders >>>consists of jahr and nr, the orderpositions references with a foreign key to >>>this table and its primary >>>key is a continual ID. > >>>In my Frontend there is a form with the ord

[firebird-support] embedded firebird in sandboxed app on MacOS

2013-12-05 Thread hamish
Hi, We use Firebird embedded in our application on MacOS. Now we're trying to run our application sandboxed and running into some trouble, with locking mostly. Does anyone have this working and could offer some suggestions? We're using the classic server 2.5, extracted from the released 2.5

[firebird-support] mon$call_stack, FK cascade

2013-12-05 Thread unordained
Inside some of my triggers, I'm trying to detect if I'm at a top-level user- requested operation, or nested inside other triggers. (I've done this for some REDO triggers before, here I'm doing it for validation reasons -- there are things I don't want a user doing directly, but don't mind cascad