The error code I get is -804 which has a number of meanings listed
in the appendix of Helen's Firebird Book. I have no idea how to
interpret them.

--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> irajoel2000 wrote:
> > I use the following sql statement with dbase tables to return

records

> > that are a certain distance from a zipcode. Each record has a

latitude

> > and a longitude and a cosine. I then cycle through the rowset

and

> > filter out those records that are <= the request milage, ie: 10

miles

> > from 10011.
> >
> > I am trying to upgrade to firebird, but the sql statement seems

not to

> > work with firebird.
>
> It would be much easier to help you if you tell us what is the

error

> message?
>
>
> --
> Milan Babuskov
> http://www.flamerobin.org
> http://www.guacosoft.com
>