What's the table update error, Lar?
>I have...
>2 simple related tables
>Using views on both to update.
>Referential integrity on the parent table has deletions cascading to the child
>SQL send updates to both with delete and insert
>Primary keys on both tables = keyfield for not dele()
>
>The child table updates fine.
>
>Any parent table update results in error. The only thing that I have been able to guess is that the parent table's delete may be trying to cascade to the the child.
>
>Is there a way that I can have the parent use the delete and insert update? I want to be able to see the previous entries.
>
>TIA
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