Hi all,
I am trying to integrate to Google Maps. Whilst I've managed to do that, I need to handle records where there is no address. Some records do not have an address as I've mashed all the FACTS into one.
What I am doing is peeking inside a field, and, if it's null, I want to move to the next i in the for loop.
If there's an address, then move to the table.
I've mucked around with a few options but none seem to work.
Be gentle, I'm just a beginner.
Here's what I have: what I end up with is a GMAP call that fails as address is often null.
let noRows = NoOfRows('Facts')-1;
for i=1 to $(noRows)
//let a=peek('Pt_FNAME',$(i),'Facts');
//let b=peek('Pt_LNAME',$(i),'Facts');
//let c=peek(‘ProductSold’,$(i),'Facts');
let address=peek('City',$(i),'Facts');
GeocodeResponse:
LOAD
status,
//'$(a)' as Pt_FNAME,
//'$(b)' as Pt_LNAME,
//'$(c)' as ProductSold,
'$(address)' as City,
([result/geometry/location/lat]) as latitude,
([result/geometry/location/lng]) as longitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);
next i;
Here's what I have come up with in the for loop, but I get a script error. Basically, the logic is: if address is null, try the next i, if it's not null, carry on to the GeocodeResponse.
let noRows = NoOfRows('Facts')-1;
for i=1 to $(noRows)
// let a=peek('Pt_FNAME',$(i),'Facts');
// let b=peek('Pt_LNAME',$(i),'Facts');
//let c=peek(‘ProductSold’,$(i),'Facts');
let address=peek('City',$(i),'Facts');
if IsNull ($address)) Then
Exit FOR
//also have tried Next i;
Else
.