Re: count row function

[Quoted] Hi Frank,

    Although I agree with you in relation to the efficency of the code. In my original post I was trying to answer the problem Sandy raised I.E. what count(*) will return when no rows are matched.

Conan

PS
Hope this is read in the spirit it was written, my self-defense rather than [Quoted] to have a go at Frank

Frank wrote in message <8p2dk7$j1l$1_at_porthos.nl.uu.net>...
>Hmmm.
>
>Typical inefficient code...
>The question you are answering is "how many clients", not
>"Does this one exist"... Credit due to Steven Feuerstein.
>
>define a cursor, open it, select.
>if NO_DATA_FOUND is raised, return 0, else 1
>
>Will use (primary key?) index (if available).
>--
Received on Tue Sep 05 2000 - 11:41:51 CEST