Thanks Martijn

Martijn Tonies <m.tonies@...> escribió: >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






---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]