Re: auto increment in select clause
From: Samuel Tribehou <s.tribehou_at_wanadoo.fr>
Date: Fri, 7 Jun 2002 12:56:19 +0200
Message-ID: <adq3ge$gia$1_at_wanadoo.fr>
Date: Fri, 7 Jun 2002 12:56:19 +0200
Message-ID: <adq3ge$gia$1_at_wanadoo.fr>
> select count(*) as inc, t1.ref as ref
> from atable t1, atable t2
> where t2.ref <= t1.ref
> group by t1.ref
> ;
Thanx alot, it works nicely.
My form can now be populated in one sec less than before :)
(I had to fill a recordset, then iterate throught it searching for the right
value,
and finally return the position of the row in the recorset...)
Received on Fri Jun 07 2002 - 12:56:19 CEST