Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
John,
>Was trying to write a demo of cascading deletes using RI, when a thought occured to me: What happens if you have RI in your DBC but have the child table in the relation open, buffered elsewhere in the app at the same time?
>
>Stuff like this is why I shy away from using built-in RI.
>
>Seems to me a nasty situation. Thoughts?
This usually gives no problem at all. The related records are deleted. When you've got a releated record open in another dataenviroment and you change the records, the TABLEUPDATE() will fail (update conflict or RI). Of course you can handle these errors and refresh the state of of the form or dataenviroment where this other child table is openend.
Walter,
Previous
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