BorlandTalk.com

d.f.s. · Guest

Hi folks;
Using BCB4-Pro and a VCL TQuery I'm trying to get into a database where
someone named a field 'LONG', for longitude. A Query->Text like:

SELECT *
FROM doXXa.dbf
WHERE (LONG <'1213800' AND LONG > '1205200')
AND (LAT < '521700' AND LAT > '513100')

Generates a improper use of keyword LONG error.

I need the single quotes because, like the LAT field some entries have text
in these fields!

Is there some way I can have LONG interpreted as a field, not a key word? Or
do I need to change the name of the field in my local copy of this db?

Thx,
Drew