Hallo Ralf,
hast du noch einen Tipp?
Wenn in der Datenbank unter Lat oder Lon kein Wert steht scheitert die Abfrage.
Wie kann ich das Filtern ? Where Lat Is Not Null ?
thx
luet
SelectStatement = "SELECT Id, PLZ, Ort, " + strKFZ + "Bundesland, DistanzInKm FROM (SELECT Id, PLZ, Ort, " + strKFZ + "Bundesland, " + _
"3.14159265358979 AS PI, " + _
"Cdbl(iif(instr(1, lat, ""."") = 0, lat, left(lat, instr(1, lat, ""."") - 1) & "","" & mid(lat, instr(1, lat, ""."")+1))) * PI / 180 AS hn, " + _
"Cdbl(iif(instr(1, lon, ""."") = 0, lat, left(lon, instr(1, lon, ""."") - 1) & "","" & mid(lon, instr(1, lon, ""."")+1))) * PI / 180 AS he, " + _
LaB + " * PI / 180 AS n, " + _
LoB + " * PI / 180 AS e, " + _
"COS(he - e) * COS(hn) * COS(n) + SIN(hn) * SIN(n) AS co, " + _
"atn(ABS(sqr(1 - co * co) / co)) AS ca, " + _
"Format(6367 * iif(co < 0, PI - ca, ca),""000.000"") AS DistanzInKm " + _
"FROM " + country + ") as innertab WHERE DistanzInKm " & Operator & " " & Entfernung + " Order by DistanzInKm ASC;"