Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Looking up values in an array
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement