FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
Array Help?
Array Help?
Débuté par Mark Nelson, 05 mar. 2015 03:56 - 1 réponse
Connectez-vous…
Mark Nelson
#1
Posté le 05 mars 2015 - 03:56
Hello I know it right in front of me. but I am going to ask. I have a list of 200,000 names or more [ FName, LName ] I would like to know how many name are there IE 20 FName of Mark/ 250 FName of John / 130 FName of Jim. Now I don't know the name(s) in the list.. I am thinking I use FileToArray (Function).. But as Andy tell's me, I am over thinking it..?
Signaler
0
0
Fabrice Harari
#2
Posté le 05 mars 2015 - 11:05
Hi Mark
1. A query getting all records, with only the fields you need
(firstname, lastname, whatever you need to count)
2. a hreadfirst/while not hout/hreadnext on the query, on the field to count
3. You count till the value changes
That's all
As it's a query, you can do that on any field, even if it's not a key,
and you can do one loop for each field to count without any extra data
access
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
NEW: WXReplication, your open source replication system is available on
my web site!!!
WXShowroom.com: Show your projects!
More information on
http://www.fabriceharari.com
On 3/4/2015 9:56 PM, Mark Nelson wrote:
Hello I know it right in front of me. but I am going to ask. I have a
list of 200,000 names or more [ FName, LName ] I would like to know how
many name are there IE 20 FName of Mark/ 250 FName of John / 130 FName
of Jim. Now I don't know the name(s) in the list.. I am thinking I use
FileToArray (Function).. But as Andy tell's me, I am over thinking it..?
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte