>SELECT MAX(GENE) FROM TEMPORALPRUEBA1 WHERE
>CLIENTID = MINCLIENTID INTO :IDMAX;
>
>and I'm getting the error
>Column unknown MINCLIENTID.
>
>MINCLIENTID is the name of a variable in the procedure:
>DECLARE VARIABLE MAXCLIENTID SMALLINT;
>DECLARE VARIABLE MINCLIENTID SMALLINT;

Use a ":" in front of variable/parameter names when used in
SQL statements.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com