Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing set/series of number in a field
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01543783
Message ID:
01543802
Vues:
65
I agree with Al, a child cursors seems like simpler and cleaner solution.

>
>I need to store a series of numbers into a field (e.g. 1, 34, 22, 33, 3333, 7 and so on) so that later in the program it can be determined if a certain number is present in this "array" of numbers. Originally I was creating an array (based on this series of numbers), converting the array into a string, storing the string in a memo field; then retrieving the string and converting it to array. Now I am thinking that maybe there is a more efficient way. What if I store this series of numbers as a string of this type:
>"1,34,22,33,3333,7" (basically converting each number into a string and then concatenating them). How would I then find out if a certain number (e.g. 3) is in the list? Using AT() will not give me the right result since character "3" is in the string but not the number 3. Anybody can suggest a more efficient method of storing this series of number and comparing them?
>
>TIA.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform