PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Query the nearest POI from a Lat/Lon geoposition
Query the nearest POI from a Lat/Lon geoposition
Iniciado por rongkh, 12,jul. 2016 20:37 - 1 respuesta
Publicado el 12,julio 2016 - 20:37
Hi,

How to query a database of Point of Interest (POI) with a LAT/LON using geodistance() ? or is there a geography data type in HFSQL ?

Appreciate any help.
Publicado el 13,julio 2016 - 23:15
Hi Kenny,

If I understand correctly the question, you first need to
define/calculate the 'square' you are looking for, then you can query
with a between on lat, and a between on lon...

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com