Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Related Tables
Message
From
16/07/1997 00:33:44
 
 
To
16/07/1997 00:24:29
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00040147
Message ID:
00040154
Views:
26
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
Map
View

Click here to load this message in the networking platform