🚀 go-pugleaf

"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote:
>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 
>
>

Thanks! Great!!!