Hi Patric.

>An update trigger is failing for a table that has a compound expression as it's primary index...ACCOUNT+DTOC(REQ_DATE)

The code generated by the RI Builder doesn't properly handle updates with compound keys (in fact, when you use the builder to generate the code, it warns you about this).

You'll have to manually edit the update trigger code for the table to specifically do what you need.

That's one of the reasons most database gurus strongly recommend using meaningless primary keys, such as automatically assigned integers. It completely avoids this problem.

Doug