That's the one, it's easy when you know what to look up :)

--
Nick
-----We Solve your Computer Problems---
UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly

> --- In firebird-support@yahoogroups.com, "Nick" <nick@...> wrote:
> >
> > If I have an insert statement within an SP is there a way to see the
> number
> > of rows that were inserted without having a separate query within
> the SP to
> > count them.
>
> Does ROW_COUNT work or is that only updates?
>
> Adam