S sconlon Active Member Licensed User Longtime User Nov 23, 2013 #1 I am importing a CSV file of names and addresses into a SQL database and want to verify each address before writing it to the database. I thought of using GetFromLocationName to see if it returns a lat/long but as I am importing each record within a FOR loop I can't see how to wait for the _GeocodeDone event and then continue inside the loop. Any suggestions?
I am importing a CSV file of names and addresses into a SQL database and want to verify each address before writing it to the database. I thought of using GetFromLocationName to see if it returns a lat/long but as I am importing each record within a FOR loop I can't see how to wait for the _GeocodeDone event and then continue inside the loop. Any suggestions?
thedesolatesoul Expert Licensed User Longtime User Nov 23, 2013 #2 You will have to ditch the loop and use a global loop, going between Geocode_Done and another sub (for instance GetNextLocationName). Upvote 0
You will have to ditch the loop and use a global loop, going between Geocode_Done and another sub (for instance GetNextLocationName).
S sconlon Active Member Licensed User Longtime User Nov 24, 2013 #3 thedesolatesoul said: You will have to ditch the loop and use a global loop, going between Geocode_Done and another sub (for instance GetNextLocationName). Click to expand... Sounds like a good approach. Many thanks for the suggestion. Upvote 0
thedesolatesoul said: You will have to ditch the loop and use a global loop, going between Geocode_Done and another sub (for instance GetNextLocationName). Click to expand... Sounds like a good approach. Many thanks for the suggestion.
