Alexandre Benson Smith wrote:

>I would creaet a flag column on the table, and set the value to
>processed on the view, and in the view check if the flag column is
>marked so don't procecess it again.
>
>

Ooops...

I don't know why I wrote view on the above phrase.. it should be TRIGGER...

So here is what I meant to say.

I would create a flag column on the table, and set the value to
processed on the TRIGGER, and in the TRIGGER check if the flag column is
marked so don't process it again.

I think I need some sleep :-)

Ladies and gentleman, good night !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005