Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What was the developer thinking?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01412303
Message ID:
01412475
Vues:
69
>Hi Naomi,
>
>>The form uses a SET FILTER. It shows records in a grid. I saw today with my own eyes (every time reproducible) the duplicate records. First one is not a dupe, then two dups. I checked two tables that may be a suspect and there were no duplicate records there.
>
>One way to get duplicate records is using a cursor with SET SKIP TO as the record source. Another one would be to use one cursor as the record source, another one for all control sources and link both with SET RELATION. A common scenario is a hit cursor. When you check this in your app, make sure you evaluate the values at runtime. What's in the grid definition might be meaningless.

Thanks again, will do.
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