i est un entier=1
TableSelect(TABLE_Table1,i)
TANTQUE i<TableOccurrence(TABLE_Table1)
HLitRecherchePremier(Address,IDZipcodes,TABLE_Table1[i][1])
SI PAS HTrouve ALORS
Address.zipcode=TABLE_Table1[i][1]
Address.city=TABLE_Table1[i][2]
Address.state=TABLE_Table1[i][3]
Address.county=TABLE_Table1[i][4]
Address.areacode=TABLE_Table1=TABLE_Table1[i][5]
Address.citytype=TABLE_Table1[i][6]
Address.City_alias_abbrev=TABLE_Table1[i][7]
Address.City_Alias_name=TABLE_Table1[i][8]
Address.latitude=TABLE_Table1[i][9]
Address.longitude=TABLE_Table1[i][10]
Address.timezone=TABLE_Table1[i][11]
Address.Elevation=TABLE_Table1[i][12]
Address.CountyFIPS=TABLE_Table1[i][13]
Address.Daylightsaving=TABLE_Table1[i][14]
Address.Prefered_last_linekey=TABLE_Table1[i][15]
Address.classificationcode=TABLE_Table1[i][16]
Address.multiCounty=TABLE_Table1[i][17]
Address.stateFIPS=TABLE_Table1[i][18]
Address.citystatekey=TABLE_Table1[i][19]
Address.cityaliascode=TABLE_Table1[i][20]
Address.PrimaryRecord=TABLE_Table1[i][21]
Address.Citymixedcase=TABLE_Table1[i][22]
Address.CityAliasMixedCase=TABLE_Table1[i][23]
Address.stateANSI=TABLE_Table1[i][24]
Address.Countyansicode=TABLE_Table1[i][25]
Address.FacilityCode=TABLE_Table1[i][26]
Address.CityDeliveryIndicator=TABLE_Table1[i][27]
Address.CarrierRouteRatesortation=TABLE_Table1[i][28]
Address.financenumber=TABLE_Table1[i][29]
Address.UniqueZIPname=TABLE_Table1[i][30]
HAjoute(Address)
FIN
i++
TableSelect(TABLE_Table1,i)
FIN
Info("terminer")
Partager