I am new to MapBasic programming.
I am trying to make multiple selection from a table where the ID number exist in my array and save all the values into another table which called results. ARRContainsValue() is a function which checks the values. This function works well. My only problem is the table result only contains the last selection, not all of them. Can anyone help me with this.
fetch first from structurepoint for i=1 to tableinfo(structurepoint,8) if ARRContainsValue(Route_IDs_Used(),route.id)=1 then select * From structurepoint where rowid=i into results noselect end if fetch next from structurepoint next