Triggers problem (or objectpointer problem)

[Bart Pietercil]

Hi List,

I am having trouble making Valentina accept this table.

The warning sign is on the field objptr_created_by. I seems always to  
loose the target table.
I can update the target table and then the warning sign disappears,  
but when I quit and reopen (not refresh because that makes VStudio  
crash) the target is lost again.
I already tried deleting the field and recreating it but that does  
not seem to help.

So the next obvious step was cloning the database. (I first set the  
target table correct)

And yes it works, the cloned database does not have the problem  
(target table is correct for the object pointer) BUT

I lost all the triggers.

When I look in the original db the triggers are there, I the cloned  
db nothing ( I did try to show it by query ("show triggers")

Nothing


Any ideas ?


This is what diagnose gives in the original database:

Something is different for the objptr_created_by (a few lines that  
are there for other objectpointers are not there for this one)

Table: tbl_rating_systems
************************************************************************ 
***

==========> Field: modification_dt , type DateTime

All right!  ( Field: modification_dt , type DateTime )

==========> Field: creation_dt , type DateTime

All right!  ( Field: creation_dt , type DateTime )

==========> Field: objptr_modified_by , type ObjectPtr
==========> IndexFile
PAGE (0, 0) Inventory pages OK.
Index Inventory pages OK.

OK.
All right!  ( IndexFile )


All right!  ( Field: objptr_modified_by , type ObjectPtr )

==========> Field: rs_name , type VarChar
==========> IndexFile
PAGE (0, 0) Inventory pages OK.
Index Inventory pages OK.

OK.
All right!  ( IndexFile )

.....> VarCharFile

All right!  ( VarCharFile )


All right!  ( Field: rs_name , type VarChar )

==========> Field: rs_description , type VarChar
.....> VarCharFile

All right!  ( VarCharFile )


All right!  ( Field: rs_description , type VarChar )

==========> Field: objptr_org , type ObjectPtr
==========> IndexFile
PAGE (0, 0) Inventory pages OK.
Index Inventory pages OK.

OK.
All right!  ( IndexFile )


All right!  ( Field: objptr_org , type ObjectPtr )

==========> Field: objptr_created_by , type ObjectPtr
==========> IndexFile
PAGE (0, 0) Inventory pages OK.
Index Inventory pages OK.

OK.
All right!  ( IndexFile )


All right!  ( Field: objptr_created_by , type ObjectPtr )


All right!  ( Table: tbl_rating_systems )


Thx

Bart Pietercil