Hi,

I have a

db.insert(tqmptc120, db.retry)

statement.

If my programm executes the following statement, a lot of lines later the programm jumps to a "retry.point" if I try this:

select qmptc037.*
from qmptc037
where qmptc037._index1 = {:i.quid, :i.test.group}
order by qmptc037.tseq, qmptc037.aspt, qmptc037.char
selectdo
.
.
.


The "commit.transaction()" will happen somewhere later.
Without the "db.insert()", reading (selection) of qmptc037 is possible, as it always should be.

I'm not sure about references between this tables. AFAIK there are none.

OK I'm on Baan 5.0c

Any suggestion is welcome


Thanx

think there is a reference with the table that will be inserted. These may cause your problem . You should control table's releations. your code should content following commands

db.retry.point()
------------------------------------------
--------- insert operations-----------------
------------------------------------------
------------------------------------------
ret = db.insert(ttdilc102,db.retry)
commit.transaction()


Good lucks ....

@mr_suleyman,

this is how my code looks like, except the fact, that there are some more db-operations between "retry.point()" and "commit.transaction()". No other db-operation like dal.insert or dal.update causes a problem, only this db.insert() on qmptc120! :confused:

Thanx

himm , it is strange situation. In my opinion , you should control your DB tree.

good lucks ...

Hej,

would it be possible that you add more fragments of your script. Like this it is really hard to say.

Are you updating the table qmptc037?

Hi malutz,

would be hard to add more, 'cause the programm flow is a little complicated. We use the phrase "extreme dll hopping" :p

But I think I'm much closer to the problem now.

Ich checked the "e" variable after Baan jumped ot the retry.point() and found a "duplicate value" error. Extended me db.insert for qmptc120 with "db.skip.dupl" things seem to work. No there is left to find out, why I tried to insert a duplicate value, because I did it in a "selectempty" loop. But that should be easier to find (I hope).

cu. Thanx for your support