Hi,

> > select * from "PAGES"
> > worked for me, whereas
> > select * from "PAGES"
> > didn't.
>
> Should be:
>
> select * from "PAGES"
> worked for me, whereas
> select * from "pages"
> didn't.

Yuk. Delimited identifiers. Better not use those.
If you're using a decent GUI tool, set it to not using
those :-)

If you would be using Database Workbench, then this
would be the case by default :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com