Good morning Experts -
I have written a procedure which uses an array to look for specific data from an Informix database. The function essentially looks for the last update date in a table and then extracts data for any missing days. The Array stores status values as depicted in the example.
Dim aStatus(3) As Double
aStatus(0) = "-1"
aStatus(1) = "-2"
aStatus(2) = "-3"
aStatus(3) = "-101"
The process loops through this array for each vendor and each days a compiles data based on the vendor, date and status. Currently I redeclare the same array for each instance which is not efficient.
I would like to just start at the first array element for each new loop. I would appreciate any assistance - Thank you
Start Free Trial
