🚀 go-pugleaf

aleplgr wrote:
>
> first I select the max and min CLIENTIDs and store them in the
> MAXCLIENTID and MINCLIENTID variables this works fine, although I'm
> not sure this is the way to do it:
>
> SELECT MAX(CLIENTID) FROM TEMPORALPRUEBA1 INTO :MAXCLIENTID;
> SELECT MIN(CLIENTID) FROM TEMPORALPRUEBA1 INTO :MINCLIENTID;

This is fine, but you could combine this into a single statement:

 SELECT MIN(CLIENTID), MAX(CLIENTID)
 FROM TEMPORALPRUEBA1
 INTO :MINCLIENTID, :MAXCLIENTID;

> SELECT MAX(GENE) FROM TEMPORALPRUEBA1 WHERE
> CLIENTID = MINCLIENTID  INTO :IDMAX;
>
> and I'm getting the error
> Column unknown MINCLIENTID.

Because it thinks you are naming a column instead of a variable. In any SQL 
statement you must include the colon ot indicate local variables:

 ... WHERE CLIENTID = :MINCLIENTID  INTO :IDMAX;

> I'm writing the procedure in EMS SQL MANAGER 2005 for InterBase/
> firebird and I'm getting the error when I compile the procedure

This will work for Firebird, but these are InterBase groups. They are 
different products that are differing more with each release. You really 
should ask Firebird questions in Firebird newsgroups for the best answers on 
that product.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
SpaceShipOne; GovernmentZero