Get(FoundCount)

Category: Get

Syntax: Get ( FoundCount )

Parameters: None

Data type returned: Number

Description:

Returns a number that represents the number of records in the current found set.

If multiple windows are open in the current database file, each window can have its own found set. If the Get (FoundCount) function is used in a script, it returns the found count of the active layout in the active window.

Get (FoundCount) is often used in scripts, following finds, to determine navigation paths. In the following script, if one record is found, the Detail layout is shown. If multiple records are found, the List layout is shown. Finally, if no records are found, the script notifies the user with a dialog box.

 If[Get(FoundCount)=1]
 Go To Layout[Detail]
 Else If[Get(FoundCount)>1]
 Go To Layout[List]
 Else
 Show Custom Dialog ["Empty Set"; "No Records Found"]
 End If

Examples:

If 240 records are in the found set, Get (FoundCount) returns 240.


: 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