In BaanIV in one session After saving the record I need to create one record
in the history table
for that After maintable io (after write) I wrote
the below chunk of code

db.retry.point()
tcmcs045.fld1 = something
tcmcs045.ld2 = something
db.insert(ttcmcs045,db.retry)
commit.transaction()

I am getting a error saying that "Transaction is on cannot continue"
where can I write this kind of code.
Is it problem with the code or problem with the place we need to write.

and also I tried after update db commit and choice.update.db

in all the places am gettting the same error
Thanks in advance

rgds,
jack

do it of this way:


tcmcs045.fld1 = something
tcmcs045.ld2 = something
db.insert(ttcmcs045,db.retry)


in the main table io all the actions of the db are linked to the transaction of the main table . You needn´t any db or commit

good luck :p

I am seeing first time in Baan code
Can u pls explain what is this <code> </code>
like HTML tags :-)

I think dorleta mean to use [] around the words code=baan. This provides the correct format. You can read the FAQ on the board to find out how to use these. I will edit your post also - then you should be able to edit it and see what I did. Of course this assumes you can edit your own post - not sure if that is possible, but since I am a moderator I can. Using the code tags just makes things easier to read.

Mark