Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Question regarding Arrays
Hi,
My question is Can an array which is created by a SELECT-SQL statement be refreshed with new data if the SELECT-SQL statement is re-ran, say from within a FOR loop? If not, how can this be done?
FOR lnBrCount = 1 TO ALEN(laBranch,1)
SELECT Loaninfo.* ;
FROM Loancomm!loaninfo ;
WHERE Loaninfo.cbranch = laBranch[lnBrCount] AND MONTH(Loaninfo.dcommdate) = lnBrCount AND YEAR(Loaninfo.dcommdate) = gnType ;
GROUP BY 4 ;
ORDER BY Loaninfo.cbranch ;
INTO ARRAY vaTest
ENDFOR
I tried RELEASE vaTest after the FOR loop, so that the SELECT statement can recreate vaTest with the new data during the next instance of lnBrCount, but it seems that it doesn't redimension the array.
Any suggestions are appreciated.
Thank you,
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