Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SCAN and DO WHILE logic
Message
 
 
À
28/10/2008 19:56:28
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01357888
Message ID:
01358218
Vues:
16
Jay,

Alternative assuming there's a primary key field available
select GroupHeading, min(PKField) ;
   from WorkListXMLCursor ;
   into cursor keepers ;
   group by GroupHeading

update WorkListXMLCursor ;
   set GroupHeading = "" ;
   where PKField not in ( select PKField from keepers )
>I'm trying to only keep the first unique value of the GroupHeading field, blanking all others like it until I get to a different value. The code below is kicking out of the DO WHILE because the value of GroupHeading is changed by the REPLACE. I understand why, but how can I get around it?.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform