Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking up values in an array
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Looking up values in an array
Divers
Thread ID:
00550067
Message ID:
00550067
Vues:
46
I have a variable (called bd) that contains a date put in by a user. I also have an array that has list of dates retrieved from a table. I am looking for a date that the user entered against the array that fetched the dates from a table. The date that I am trying to retreive from array has to be either >= user inputted date. What is the fastest way to search for a date in an array that can be greater than or equal to value user input

&&user inputted date
bd=.t1.value

&& dates from table
SELECT DISTINCT (bdate) FROM payroll!payroll_tbl into array a__gen1

I tried the ascan but I don't think it supports >= expressions.

Thanks
Nick Patel
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform