Re: How do I get a block record count ?

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B4B6C39.CF83E68C_at_attws.com...
> 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
> > >
> > >
>
> If that is what you are doing another method, presuming at least one of
 your
> fields is set to NOT NULL would be to go to the detail block and see if
 the
> field has a value.
>
> Daniel A. Morgan

This works OK if the current row happens to be set on a valid record. In my forms at least I can position the current record to a blank record.

John Received on Wed Jul 11 2001 - 18:26:22 CEST