ldc@cbnewsm.ATT.COM (derrick.j.mitchell) (01/06/90)
When you are using the SET RELATION in Clipper and issue a DELETE, does the DELETE command affect the data file that the RELATION is set to? For example: USE customer SET RELATION TO name IN supplier GOTO 4 DELETE && Will the record in "supplier" be marked as delete. Thanks in advance.
awd@dbase.A-T.COM (Alastair Dallas) (01/17/90)
In article <8307@cbnewsm.ATT.COM>, ldc@cbnewsm.ATT.COM (derrick.j.mitchell) writes: > When you are using the SET RELATION in Clipper and > issue a DELETE, does the DELETE command affect the data file > that the RELATION is set to? No, at least not in dBASE. Relations are often used, for example, to refer a transaction table with a customer table. Just because a single transaction is being deleted should not imply deleting the customer as well. You can do that, easily, but the system doesn't assume you want to. /alastair/