Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement