--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> googlepost123 wrote:
>
> >Hi,
> >
> >I just started to use Firebirs so I am a newbie. I first started

out

> >using the Firebird ODBC driver to connect Brio client to the
> >employee.fdb example. I had no problems querying this db. I then
> >created a new fdb and created one table, and then created the ODBC
> >connection. I then connect to the new fdb using Brio and it sees

the

> >single table but when I try to query it I get the error "SQL Error
> >Code = -204, Table unknown". Why am I getting this?
> >
> >Dave
> >
> >
> Dave,
>
> Give us a bit more information...
>
> What the Create table Statement ?
>
> What is the select statement that are giving errors.
>
> I could think a thing at first sight, Quoted Identififers.
>
> When you create a table like this:
> create table "Foo"(a integeer);
>
> you should ALWAYS use
> select * from "Foo"
>
> Quoted Identifier is a pain....
>
> see you !
>

I use IBOConsole to create the table so I don't know if double quotes
where used. All I know is that both Brio and MS Access cause a ODBC
error "unknown table" when trying to query it. MS Access won't let me
put " around the table name as it says invalid syntax. In Brio I
can't change the from clause and it doesn't use " to enclose the table
name. Please advise.

Dave