Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find Similar Records in a Cursor and Exclude One
Message
 
 
À
14/02/2008 16:33:28
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
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 8 SP1
Divers
Thread ID:
01292797
Message ID:
01292835
Vues:
24
This message has been marked as the solution to the initial question of the thread.
>I have a table. Some field values are saved to memory variables for the current record. I then run SQL to get all records from the same table that match the field values. These are not duplicate records, just matching according the values of those specific variables from the current record. This works well, but I then need to exclude the original record from the resulting cursor. So, I want the ones that match, but not the one that I used to create the criteria.
>
>UPDATE: I think I may be able to use RecNo() for this. Testing now, but if anyone knows of something better or an issue with using RecNo(), let me know.

RecNo() is what I would use, too.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform