Helen Borrie wrote:

> At 09:43 AM 12/07/2005 -0400, you wrote:
> >The only strangeness here is that the edit queries need the following
> >quoting:
> >update "TODOS "
> >set
> > shortdesc= :shortdesc,
> > category = :Category
> >where
> > ID = :OLD_ID
> >
> >(This may be the problem and may be related to the tools I am using with
> >FIREBIRD to layout my tables)
>
> It's part of the problem. If you define objects with quoted identifiers
> then you are stuck with having to use the quoted identifiers
> everywhere. Recommendation: if you don't need quoted identifiers then
> recreate the database without them and pump in your data.

Is there a way to know that the table name has been created in a funny
manner? I found that in IBO, the main SQL query does not need the
quotes, but the update and insert queries do.

I have been using FlameRobin and IBEase+ to work with my tables, and I
am pretty sure that one of them mucked up the name, but I don't know
which one, and I cant figure out how to tell.

Is there a better tool to interactivly modify my Database schema.

Carl