Get(TotalRecordCount)

Category: Get

Syntax: Get ( TotalRecordCount )

Parameters: None

Data type returned: Number

Description:

Returns the total number of records in the current table (not table occurrence), regardless of the state of the found set.

The Get (TotalRecordCount) function is most often used in unstored calculations and scripts. Be sure to navigate to a layout that establishes the correct table context before referencing the function.

The total record count includes records that have been created but not yet committed. If such records are reverted, the total record count is decreased.

Examples:

Function

Results

Get (TotalRecordCount)

Returns 283 when there are 283 records in the current table, regardless of the size of the current found set.


: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net