General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>I have three tables namely 1. empmain 2. salary 3. recovery. The empid field is common for all three tables. I want to delete the record at once for all tables based on empid field. The empid field is Integer data type.
>>
>>How to delete the record?
>
>If you always want to delete related records in "child tables" when you delete a record in the "parent table", you can set up referential integrity rules in the database. In that case, Visual FoxPro will create the corresponding triggers, in the database, to delete the related records automatically, any time you delete the parent record (even if you delete it manually, for example in a BROWSE window).
I wondered if I should mention RI - if the OPer does not know the syntax, RI probably would be overkill. If the delete was restricted, it was a badly formulated OP ;-))
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