Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all, I'm trying to do an exit for inside a load statement and i don't know how to do that.
Basically I'm conecting to google maps to get geodata, but If I have a OVERLOAD_MESSAGE I want to do an exit for
FOR
j = 0 to $(NumberOfZips)-1
LET
K = peek('vZip', '$(j)', 'tmpzip');GMAP:
LOAD
text
('$(C)') as COUNTRY,text
($(K)) as [POSTALCODE],
[result/geometry/location/lat]
AS Latitude,
[result/geometry/location/lng]
AS Longitude
I want to add that
if [result/status]='OVER_QUERY_LIMIT' EXIT FOR
FROM
[http://maps.google.com/maps/api/geocode/xml?address
next
Thanks for your help
You were almost there. The syntax is:
For i = 1 to 10
y = i * 5
If y > 40 Then
Exit For
End If
Next
But...
How can I do that inside a load Sentence.
Only I have to exit for if on load contition is true
Best regards.
Hello Jordi,
If I'm not wrong, syntax is
FOR ... EXIT FOR WHEN Field = Value ... NEXT
Regards