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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only