Product Logo

CNS Query

Query your databases without relationships.

Functions

CNSQuery_TOExists

NameCNSQuery_TOExists
Description

This function checks for the Existence of a Table Occurrence in the current Database File. The parameter is the Name of the Table Occurrence to look for.

Return TypeNumber (1=True, 0=False)
FormatCNSQuery_TOExists ( TOName )
Required Parameters
TOName

The Name of the Table Occurrence to search for. In FileMaker Pro 11 and above, you can optionally specify the Database Filename (without the “.fp7” extension) containing the TO in the format “FileName.TOName”.

Examples
Example 1

Returns 1 when a Table Named "MyTable" exists in the current Database File.

CNSQuery_TableExists( "MyTable" )
Example 2

In FileMaker Pro 11 and above, use this form to check for a Table Occurrence in a separate, open Database file.

CNSQuery_TOExists( "AnotherFile.MyTable" )