Subject Re: [ib-support] Is there any way to get the record count from the for select or select statements??
Author Claudio Valderrama C.
Post date 2002-01-10T04:50:53Z
""Burak OZLER"" <burak.ozler@...> wrote in message
news:000c01c19859$6024cba0$2464a8c0@......
> Hi all
>
> Is there any way to get the record count from the for select or select
> statements at sp/triger codes like rows affected?

Unlike client applications, triggers and stored procs do not have access to
those counters. If you are doing a FOR loop, you can have your own variable
incremented in the loop.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing