Get(FoundCount) function.. dumb question maybe.

[Cabinetman]

I'm using the Get(FoundCount)function in a calculation field on a layout.

Shouldn't it give me the # in the found set after a find rather than the total record count in the table?

If not what should I use to get the found set count if I'm not showing the status area?

Thanks

[Raybaudi]

Hi

you have to set that calculation unstored.

[Cabinetman]

:

&*^@&%^@&$^&$^

LOL....Thanks!

[color:red]PS: What about in a related table? It's showing 1 instead of 250

Edited October 4, 2008 by Guest

[mr_vodka]

for the number of related records you should use Count ( ChildRelationship::PrimaryKey )

[Cabinetman]

They're not related records.... related tables only.

Premise:

I do an update of records in table2 by internet import 10 at a time based on a found set in table1 marking them as they come in.

At the end I do a find in table2 and check the count in the 2nd table to make sure that it didn't miss any...

Edited October 5, 2008 by Guest

[mr_vodka]

I'm not sure what you are getting at. If you capture the number of records in your found set of your first table and then after the import and find in the second table, you can compare the found counts of both.

[Cabinetman]

I didn't see where this was headed so a more detailed explanation was prob. required.

Note: I did figure it out. I'll explain below...

Table1 contains items listed. These are unique by SKU but there can be duplicate UPC's or ISBN's (duplicates because they can be in different condition or even just a diff. price for some reason)

Table2 is a catalog with Unique SKU and UPC/ISBN

I run a script to check pricing in Table2.

To make sure that no records from Table1 were skipped or not updated for some reason in Table2 I needed to check the found count in Table2 (updated=yes) verses a unique count in Table1.

Ssssoooo I ended up using a self relationship in Table1 based on a calc field that chooses UPC/ISBN

Table1 field1 is calc. Get (record ID)

Table1 field2 is calc. If (field1 = Table2::field1 ; "1"; "")

Table1 field3 is summary = total of field2

Now I have a count of the total unique records in the listings table (table1) and can compare it to table2's found count after updating.....

Whew!

Sorry but thanks for all the help. Hopefully this will help someone else also......

[color:red]Only problem....

The field from Table2 that is a Get(FoundCount) when put into Table1 only shows "1" instead of the 300+ in the current found set in Table2... which it does show in Table2.

Edited October 5, 2008 by Guest

[mr_vodka]

The FoundCount is reflective of the active window's layout / table occurrence. Therefore if you are trying to access it based on a layout of table 1 it will not work trying to get the count.

You can either capture the found count number in a variable when on table 2's layout or if manually checking it then you can pop open a new window since each window will retain their found sets.