What the ...

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

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 firebird-support@yahoogroups.com, Hans <hhoogstraat@s...>
wrote:

> 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

product_'

> +
> 'vendor')
>
> Yes.. Seriously ...
> Happy 2005
>
>
> [Non-text portions of this message have been removed]