Subject Re: [IBO] IB Basics?
Author Helen Borrie
At 02:17 PM 29-12-00 +0200, you wrote:
>I get a plan error! All that I am doing is connecting a ib_query to a
>When I double click on the ib_connection component and go to the SQL tab, I
>get the above error.
>When I run the application and open the query, I get an SQL -204 error,
>table unknown?

Did you declare the table with quoted identifiers?
If you did
CREATE TABLE "hEaVeN" ("COL1", "col2", "Col3")

Then your SQL must be

SELECT "COL1", "col2", "Col3"

It makes life a WHOLE lot easier if you don't use quoted identifiers at
all. Only user them if you really MUST (e.g. you are converting from a
different database and you want to keep "illegal" identifier names such as
reserved symbols or column names that contain spaces).

All for Open and Open for All
InterBase Developer Initiative ยท