Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql counting duplicates, possible
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01620702
Message ID:
01620734
Vues:
39
no, with curFinal open, I first used Browse. Looked at the data. Then to show you, I used a: copy to myText type csv fields mDate, Vs, mRec, Keepinfo, cntdups, curDups.MinVs. I then formated the data in Word and presented it here. keepInfo is still doing what is shown below.

>>
>>Table myTable
>>field names------Type----number of characters
>>mDate-------------D------8
>>Vs----------------C------200
>>Debit-------------N------12 with 2 decimals
>>
>>
>>output from curDups
>>
>>
>>minvs------mdate----------cntdups
>>conso------05/28/2013------3
>>henr-------08/28/2013------2
>>key--------09/16/2013------2
>>menu-------09/18/2013------2
>>
>>
>Ok, everything is correct then according to the logic. I assume you manually typed your previous result and didn't type minVs correctly.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform