Subject | RE: [ib-support] Extra Field? |
---|---|
Author | Leyne, Sean |
Post date | 2001-08-24T14:49:39Z |
Mike,
What programming language do you use?
I would think that you could create a UDF to calculate and return the
distance, which you could then sort by. The UDF call would look like:
SELECT DISTANCEUDF( :TargetPointLat, :TargetPointLong, LATITUDE,
LONGITUDE), COLUMNS, ..., FROM ... WHERE ... ORDER BY 1
Sean
P.S. Mike, what to over-quoting -- thanks.
What programming language do you use?
I would think that you could create a UDF to calculate and return the
distance, which you could then sort by. The UDF call would look like:
SELECT DISTANCEUDF( :TargetPointLat, :TargetPointLong, LATITUDE,
LONGITUDE), COLUMNS, ..., FROM ... WHERE ... ORDER BY 1
Sean
P.S. Mike, what to over-quoting -- thanks.