How to count total records

[Goldkim]

Hi, all,

I tried count (field) and it always return 1 although I changed several fields. Does any one know how to count the total number of records in a database. It should very easy but I just can not get it. thanks.

[SlimJim]

Make a second occurrence of your table and relate them by X so all records are related to all records. Call the second table occurrence Counter. Then count(Counter::field) will give you the total number of records. (I'm sure there are other ways of doing it.)

[Goldkim]

Hi, Slim Jim

It works for me. Thanks a lot.

[LaRetta]

"how to count the total number of records in a database."

Ummm, maybe Get(TotalRecordCount) would do what you wish also? If you use a self-join to count, remember to count a field which always contains something, like a serial or ID. If the field being counted is empty, it won't, ummm, count. :(

[SlimJim]

I thought there might be other ways of doing it.

I keep a cartesian join alongside most of my tables for ID control. So it is natural to use it for table stats, and I do count the ID field (Should have mentioned that, thanks for pointing it out.)

[SlimJim]

I've tried to respond to this once already so if this is a repeat - apologies.

I knew there would be other methods.

I keep a cartesian join alongside most of my tables for ID control so it is natural to also use it for full table stats. I do count the record ID and I should have said that. Many thans for pointing it out.

[Ender]

For large tables, counting through the relationship will end up slowing things down unnecessarily. It's better to use the Get() function in this case.