Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing order in child table when using SET RELATION
Message
 
 
À
02/05/2000 13:37:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00365204
Message ID:
00365226
Vues:
13
>How do I do to change the order of a child table that is connected to his parent with set relation? Is it even possible (using the SET ORDER command)?

No. SET RELATION cause an implict seek in the child table whenever the record pointer is moved in the parent table. If the order is set to a different tag in the child table, you could find no child records or, even worse, the wrong records.

My suggestion would be to use parameterized views instead. You could requery the view when you moved the record pointer in the parent table and build sorting indexes for your child cursor.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform