Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL DISTINCT PROBLEM - VFP5.0a
Message
De
09/08/1999 11:02:01
Greg Coopman
Gc Systems Corporation
Hollywood, Floride, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL DISTINCT PROBLEM - VFP5.0a
Divers
Thread ID:
00251466
Message ID:
00251466
Vues:
46
I have found a problem that is perplexing to me. It does not make sense, and I have also confirmed the problem with one of my foxpro associates. I am running a Select distinct fieldname from table command and have set deleted on. The result acts as if set deleted is set to off and is picking up my deleted records. After adding a tag index for deleted() to the table I am selecting from, the result acts appropriately. I've tried this on two different computers in the office. In VFP6 it works correctly, or at least as I expect it to. Has anyone else ever experienced this problem in VFP5?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform