Subject Re: [IBO] Trouble with Insert Into
Author Markus Ostenried
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: