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.

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.

Example 1

Returns something like:<br/> MyTable=1065089<br/> AnotherTable=1065092

CNSQuery_GetTOIDs

---

Example 2

Returns 1065092 if the TO ID for the "AnotherTable" Table in the current Database File is 1065092.

CNSQuery_GetTOIDs( "AnotherTable" )

---

Example 3

In FileMaker Pro 11 and above, use this form to get all the Table Occurrence IDs from a separate, open Database file.

CNSQuery_GetTOIDs( "AnotherFile." )

---

Example 4

In FileMaker Pro 11 and above, use this form to get the Table Occurrence ID from a Table Occurrence in a separate, open Database file.

CNSQuery_GetTOIDs( "AnotherFile.MyTable" )