Paul,

Firstly, unless your post has anything to do with "MAX and SUM in the
same query" (which it doesn't), do not hit "Reply". Even deleting the
subject line and the text (which you didn't) is not enough. There are
headers inside the email that groups it automatically in some
news-readers. Not only does it confuse people when they get your
message in the middle of another thread, it also means that a lot of
people are ignoring your message because they don't realise it is in
the middle of a thread they may think they can offer no assistance to.

> I have FB 1.5.3 database with dialect 3.
> I want to use some codification with lower and upper case for table
> naming.

To me this is crazy. If you want to use lower/upper case, then it must
be used in exactly that syntax everywhere. If you try and run

select *
from table

when it is defined as "Table", it will fail.

> So, I have created tables with lower case and with upper case, using
> IBExpert.
>
> Index definition for lower case:
> ALTER TABLE "sys_company" ADD CONSTRAINT "pk_sys_company" PRIMARY KEY
> ("com_id");
>
> Index definition for upper case
> ALTER TABLE SYSCOM ADD CONSTRAINT PK_SYSCOM PRIMARY KEY (COMNUM);
>
> I wonder why for lower case I have "" for names ?????
>

The quotes tell it you want it to be case sensitive. I highly
recommend against using it. If you have a table called TABLEA, then
the following queries are considered identical.

select * from TABLEA
select * from tableA
select * from TableA
select * from tABleA

Adam