Subject | TIB_Query: Problem with SQL Parsing? |
---|---|
Author | dp078 |
Post date | 2003-09-08T16:30:46Z |
Hello,
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?
On a separate note, BeforeOpen event (where I tried to put that
patch code) didn't fire at all before opening TIB_Query. Why?
Thanks,
D.P.
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?
On a separate note, BeforeOpen event (where I tried to put that
patch code) didn't fire at all before opening TIB_Query. Why?
Thanks,
D.P.