Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert before
Message
 
À
05/07/2006 13:05:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01133860
Message ID:
01133984
Vues:
19
>Hi Mike,
>I want records reorederd in right table not only in grid and without indexes on tables and
>without field which connects rows; rows on right are grouped together for left row, then follows rows for second left row and so on ...
>Regards, Gojko

Hi Gojko,

Yes this can be done programmatically but if you don't use indexes, even hidden to the user it gets slower and slower every time when records added.

Another penalty is that if no "key" is used between records in table A and B, after even a small corruption you are mixed to the greatest mess ever. Every time you open, look or reorder table B, the situation is "static" and hard to repair after a possible corruption OR user error (yes those can happen in real world) but with a index/relation key (you can use even a third "hidden to user" table to relate tables A and B) the situation is "dynamic" and much less harm you will get.

AT
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform