Auto code - Help

Hello all (:

I'm making a program, when I put the auto code script to generate code for clients, citys I receive this error:

Dynamic SQL Error
SQL Error code: -206
Column unknown CODCLIENTE
At line 1, column 12
-----------------------------

I was make a auto code for the city table, the script in the SQL statement is: select max (codcidade) as MAIOR from cidade...it's all OK

But when I do with client table I received the error above.
The script is completely right, the table name is right, column name too, but I don't know what is happening ;/
------------------------------------------
The table code is here:
/* Table: CLIENTE, Owner: SYSDBA */

CREATE TABLE "CLIENTE"
(
"codcliente" INTEGER NOT NULL,
"nomecliente" VARCHAR(60),
"codcidade" INTEGER,
"telefone" VARCHAR(11),
"endereco" VARCHAR(80),
"comentarios" VARCHAR(300),
"devedor" FLOAT,
"expiraem" DATE,
"comprasfeitas" INTEGER,
CONSTRAINT "PK_CLIENTE" PRIMARY KEY ("codcliente")
);

------------------------------------------------
please someone help me and sorry, I don't speak english very well =P

First, the SQL you posted does not relate to the table you posted. Why?

Second, if you are going to use case sensitive column names ("codcliente"),
which is not recommended, you have to follow through EVERYWHERE.


Hope this helps.
Clive

Thanks, it works