The statement has been terminated. The definition of object

[jsantos98]

Hello!

I have another problem while upgrading an old project from BDE and ADO to SDAC

Now, I come up with the error:
The statement has been terminated. The definition of object 'xxxx' has been changed since it was compiled.

I've trackdown the problem and found that the table has a trigger. That trigger inside has some code and in one condition, it disables it self, updates some records in the same table and then enables itself.

Code: Select all

ALTER TABLE TAB_TARF DISABLE TRIGGER TAU_TAB_TARF
update xxxxxxx
ALTER TABLE TAB_TARF ENABLE TRIGGER TAU_TAB_TARF

I believe this is the problem...
(This was working in the previous version using BDE)

Is there any option I can disable on the dataset to solve this?[/code]

[Challenger]

We have not encountered such problem before. Please send us a small sample to reproduce it..