Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX problem or bug
Message
 
 
À
09/07/2007 09:18:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01238557
Message ID:
01238596
Vues:
8
>>>>Why do you do the index if they are already on the form, in the DE, in parent-child relationship? The movement of the file pointer in the parent table should automaticall fetch the child recs for the parent, in the grid.
>>>>
>>>>Terry
>>>
>>>Because of sorting for display purposes.
>>
>>When you create a new index you may be breaking relationship between your tables. You may need to re-establish relationship after that.
>
>But I don't break relationship. I have checked in Data Session, relationship is there and when I browse tables everything is ok, data is there as it should be, only thing is that is not showed in Form. That's why I think it's a bug.

What was the relationship based on and what was your index expression? In any case, you may temporary remove relation and re-set it after INDEX ON command. You may also would have to move record pointer.

Or use predefined indexes as Mike suggested.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform