Subject Re: Best SQL of 2004
Author Adam
What the ...

Adding distinct to force it to return the value only once is a nice

I have seen a couple of after delete triggers attempting to remove
child records, even though there is a foreign key constraint that
cascades the delete automatically, but that is great.

--- In, Hans <hhoogstraat@s...>
> Just for fun :)
> Best 2004 SQL statement found in a sever/client application in the
client code, programmed by a local Interbase development company
announcing themselves to be technology world leaders.
> SQL.Strings = (
> 'SELECT DISTINCT(GEN_ID(vendor_gen, 0)) as genvalue FROM
> +
> 'vendor')
> Yes.. Seriously ...
> Happy 2005
> [Non-text portions of this message have been removed]