Delete elements from array

[sal21]

I create an array from sql to get 3 value from fields for example:
Sql="f1, f2 f3 from eccc"
Now i fill array with:
Set rs Getrow()
Array eccc

Now i need to delete all
elements from array where the related element of rs f1="aa"

Note:
Rs f1 not contain duplicates

[HansV]

You could change the SQL to

Code: Select all

Sql = "SELECT f1, f2, f3 FROM sometable WHERE f1<>'aa'"