Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to set relationship between 2 database?
Message
 
 
À
15/01/2001 11:29:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00463731
Message ID:
00463804
Vues:
12
SET RELATION TO... is just a convenient way to automatically move the record pointer in table B when you move the record pointer in table A ... think of it as a SEEK() command that automatically seeks in the related table for the expression used the SET RELATION TO command.

So no, in my opinion, you should not try to use SET RELATION TO to restrict data inserts or updates or deletes - I'm not even sure how you could.

Take a look at CREATE TRIGGER - that is a type of stored procedure that is stored in the database container, that you set to execute when data is about to be changed. I do not use database containers for things like triggers - I would use the backend database such as SQL or ORACLE - so I cannot help you much more on how to use database container triggers.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform