CNSQuery_GetTOIDs

Name

CNSQuery_GetTOIDs

Description

This function returns either the ID of a specific Table Occurrence or a list of “TOName=TOID” pairs for all Table Occurrences in the Database File. If you specify a TO Name in the first parameter, CNS Query will return the Table Occurrence ID of that specific Table Occurrence. If you do not specify this parameter, CNS Query will return a list of “TOName=TOID” pairs for all the TOs in the Database File. By default, CNS Query will check to make sure the TO Name you specify exists before getting the Table ID. If you already know for sure that the TO Name exists, you can pass True as the second parameter.

Return Type

Text or Number

Format

CNSQuery_GetTOIDs ( TOName ; SkipTONameCheck )

Optional Parameters

TOName

If you specify this parameter, CNS Query will return the ID of the Table Occurrence you specify. Specify “” to return the Table Occurrence IDs of all Table Occurrences. In FileMaker Pro 11 and above, you can optionally specify the Database Filename (without the “.fp7” extension) followed by a period to retrieve all the Table Occurrence IDs in that file (eg. “FileName.”). Also 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”.

SkipTONameCheck

If True, CNS Query will not check to make sure the TO Name you specify actually exists.