> I have a TIB_Query component with a very simple SQL statement
> assigned at design time to SQL property:
>
> ----------------
> SELECT
> *
> FROM
> DEALS
> ----------------
>
> However, it gives me the following error when trying to open the
> query:
> ----------------
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 4, char 6
> ,
> ----------------
>
> When I programmatically removed CR and LF characters (#13#10) from
> SQL.Text before opening a query, all worked fine.
>
> What is wrong here?

There is very likely a bug in my parsing of the query statement. I recently
had to make some changes looking for the FIRST/SKIP tokens and I could have
messed something up.

I'll give this a closer look and try and get a fix in the next sub-release.

You might try looking in my code and patching it. If you do, please let me
know.

> On a separate note, BeforeOpen event (where I tried to put that
> patch code) didn't fire at all before opening TIB_Query. Why?

The error is happening prior to opening the query so you don't see it yet.
The error happens in the Prepare phase.

> Thanks,
> D.P.