The statement has been terminated. The definition of object

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jsantos98
Posts: 7
Joined: Tue 07 Oct 2008 11:29

The statement has been terminated. The definition of object

Post by jsantos98 » Mon 20 Oct 2008 12:59

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
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Wed 22 Oct 2008 08:49

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

Post Reply