Subject | Re: [firebird-support] Row count for all tables |
---|---|
Author | Norman Dunbar |
Post date | 2011-03-29T18:54:07Z |
On 29/03/11 16:56, Alexandre Benson Smith wrote:
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
> try this:A nice piece of code Alexandre! And so much nicer than my effort! :-)
>
> SET TERM ^ ;
> EXECUTE BLOCK
> RETURNS (
> TableName Varchar(31),
> RecordCount Integer )
> AS
> begin
>
> ...
> ...
>
> end^
> SET TERM ; ^
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767