PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Array Help?
Array Help?
Débuté par Mark Nelson, 05 mar. 2015 03:56 - 1 réponse
#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..?
#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..?
→ Revenir à WINDEV 2024