On Sat, Aug 13, 2011 at 20:15, Thomas Steinmaurer <ts@...> wrote:

> Hi Dave,
>
>> I keep getting an error
>> "Token unknown - Line 1, Column 27
>>   ACTIVE"
>> which is the "A" in Active in this line...
>
> ACTIVE is a reserved word, thus you have to enclose it with
> double-quotes to use it as an identifier.

To avoid further headaches I'd suggest using a different column name.
If you can't use anything else then you have to use the same case as
when the column was defined -- every identifier inside double quotes
is case sensitive.

Reserved words in FB 2.5:
http://www.firebirdsql.org/refdocs/langrefupd25-reskeywords-full.html

HTH,
Markus