FileMaker 9, mac OS X 10.4.10

Database of several tables.

In one table defined fields for displaying navigation status on the
layout. Used the functions. Want to show total number of recordsin the
table, number of records in the found set, and record number of the
current record in the found set in the current sort order. Used the
functions:

Get(TotalRecords)
Get(FoundCount)
Get(RecordNUmber)


Total records displays the expected number. OK.

Get(FoundCount) displays the total records, not the found count! Not OK!

Get(RecrdNumber) seems to be displaying the RecordID, not the record
number in the current found set in the current sort order like it is
supposed to. Not OK!

Ideas? Bug?

--
For email, change <fake> to <earthlink>
Bill Collins

In article
<bbcollins-C68E21.01310220082007 [at] 032-478-847.area7.spcsdns.net>, Bill
<bbcollins [at] fake.net> wrote:

> FileMaker 9, mac OS X 10.4.10
>
> Database of several tables.
>
> In one table defined fields for displaying navigation status on the
> layout. Used the functions. Want to show total number of recordsin the
> table, number of records in the found set, and record number of the
> current record in the found set in the current sort order. Used the
> functions:
>
> Get(TotalRecords)
> Get(FoundCount)
> Get(RecordNUmber)
>
>
> Total records displays the expected number. OK.
>
> Get(FoundCount) displays the total records, not the found count! Not OK!
>
> Get(RecrdNumber) seems to be displaying the RecordID, not the record
> number in the current found set in the current sort order like it is
> supposed to. Not OK!
>
> Ideas? Bug?

A common mistake made in this situiation is forgetting to set the
Calculation fields to NOT be stored. If they are stored you can get
peculiar looking results, but when they're not stored you'll get the
correct numbers.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

In article <200820071812290648%helpful_harry [at] nom.de.plume.com>,
Helpful Harry <helpful_harry [at] nom.de.plume.com> wrote:

> In article
> <bbcollins-C68E21.01310220082007 [at] 032-478-847.area7.spcsdns.net>, Bill
> <bbcollins [at] fake.net> wrote:
>
> > FileMaker 9, mac OS X 10.4.10
> >
> > Database of several tables.
> >
> > In one table defined fields for displaying navigation status on the
> > layout. Used the functions. Want to show total number of recordsin the
> > table, number of records in the found set, and record number of the
> > current record in the found set in the current sort order. Used the
> > functions:
> >
> > Get(TotalRecords)
> > Get(FoundCount)
> > Get(RecordNUmber)
> >
> >
> > Total records displays the expected number. OK.
> >
> > Get(FoundCount) displays the total records, not the found count! Not OK!
> >
> > Get(RecrdNumber) seems to be displaying the RecordID, not the record
> > number in the current found set in the current sort order like it is
> > supposed to. Not OK!
> >
> > Ideas? Bug?
>
> A common mistake made in this situiation is forgetting to set the
> Calculation fields to NOT be stored. If they are stored you can get
> peculiar looking results, but when they're not stored you'll get the
> correct numbers.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thanks to Helpful Harry! That was it!

--
For email, change <fake> to <earthlink>
Bill Collins