I am trying to insert a record of suppliers in different companies. I run my application in one company (206) I insert the record here and the I try to insert the same record in the company 207 and 208. To go there I use the sentence switch.to.company. Everything works fine except at the moment the application reaches the commit.transaction sentece. At this point the application gives error 100 (Duplicate values) because it tries to commit the transaction in company 206 where the record was already inserted.

Has anybody tried these. What should I do?.

Try -


<tablename>._compnr = <new.company.no>
db.insert(t<tablename>, db.retry)
commit.transaction()

Thank you very much. It works just fine with your solution.