Re: How do I get a block record count ?

[Quoted] [Quoted] For those who are interested, I found the answer.

In the block you wish to count records in...

1. set the block property "precompute_summaries" to YES.
2. create a non visible text item, call it "record_count" or similar. Set the datatype to number.
3. set the item proporties for the "record_count" item as follows.
4. Calculation mode "summary".
5. Summary function "Count"
6. Summary Item "any primary key item name within the block"

[Quoted] This "record_count" item will now reflect the actual number of records in [Quoted] the data block regardless of any updates, deletions, additions.

John

"John" <john_millhouse_at_yahoo.com> wrote in message news:PGF27.10$dh4.1552_at_nnrp1.ptd.net...
> This would seem simple enough, but I can't find anything on it in the
 help.
>
> How do I determine the number of records in a detail block ?.
>
> Before commiting I need to make sure there is at least one record, any
 ideas
> ?
>
> Thanks in advance
> John
>
>
Received on Tue Jul 10 2001 - 22:36:06 CEST