Re: How do I get a block record count ?

John wrote:

> 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.
> a) Calculation mode "summary".
> b) Summary function "Count"
> c) Summary Item "any primary key item name within the block"
>
> This "record_count" item will now reflect the actual number of records in
> 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
> >
> >

[Quoted] If that is what you are doing another method, presuming at least one of your [Quoted] fields is set to NOT NULL would be to go to the detail block and see if the [Quoted] field has a value.

Daniel A. Morgan Received on Tue Jul 10 2001 - 22:57:29 CEST