Name | CNSQuery_GetBaseTableNames |
---|
Description | Note: This function is only available in FileMaker Pro 11 and above.
This function returns either the Base Table Name of a specific Table Occurrence or a list of “TOName=BaseTableName” pairs for all Table Occurrences in a Database. If you specify a TOName as the first parameter, it will return the Base Table Name of that Table Occurrence, otherwise it will return all Base Table Names. By default, CNS Query will check to make sure the Table Occurrence Name you specify exists before getting the Base Table Names. If you already know for sure that the TO Name exists, you can pass True as the second parameter.
|
---|
Return Type | Text |
---|
Format | CNSQuery_GetBaseTableNames ( TOName ; SkipTONameCheck ) |
---|
Optional Parameters | - TOName
If you only want the Base Table Name of one Table Occurrence, specify its Name here. Specify “” to return the Base Table Names 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 Base Table Names 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.
|
---|
Examples | - Example 1
Returns something like:<br/>
Students=People<br/>
Teachers=People CNSQuery_GetBaseTableNames
- Example 2
In FileMaker Pro 11 and above, use this form to get the Base Table Names of all Table Occurrences in a separate, open Database file. CNSQuery_GetFieldIDs( "AnotherFile." )
- Example 3
In FileMaker Pro 11 and above, use this form to get the Base Table Name of a Table Occurrence in a separate, open Database file. CNSQuery_GetFieldIDs( "AnotherFile.MyTable" )
|
---|