GetSourceFileName ( NameTableOccurrence )

Return source file name by table occurrence name.

Average rating: 4.1 (8 votes) Log in to vote

Koji Takeuchi - Show more from this author
TonicNote, Inc.
https://tonicnote.com

Sample input:

GetSourceFileName ( Get ( ActiveFieldTableName ) )

Sample output:

"Master"

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
GetSourceFileName ( NameTableOccurrence )
2017.01.01, Koji Takeuchi <takeuchi@nemoux.com>


description:
	Return source file name by table occurrence name.
ex1:
	When cursor is in field object "Customer::nameLast" field on layout on "Main" file and the field is referenced to "Customer" table on "Master" file.
	GetSourceFileName ( Get ( ActiveFieldTableName ) )
	 -> "Master"
*/

Let (
[
NAME_TO =
	NameTableOccurrence ;
QUERY =
	"SELECT " & ¶ &
		"BaseFileName " & ¶ &
	"FROM " & ¶ &
		"FileMaker_Tables " & ¶ &
	"WHERE " & ¶ &
		"TableName = ?" ;
NAME_FILE_SRC =
	ExecuteSQL ( QUERY ; "" ; "" ; NAME_TO ) ;
LENGTH =
	Case (
		PatternCount ( NAME_FILE_SRC ; " (" ) and
		Right ( NAME_FILE_SRC ; 1 ) = ")" ;
		Position ( NAME_FILE_SRC ; " (" ; 1 ; 1 ) - 1 ;
		Length ( NAME_FILE_SRC )
	) ;
NAME_FILE =
	Left ( NAME_FILE_SRC ; LENGTH )
] ;
NAME_FILE
)

description:
Return source file name by table occurrence name.
ex1:
When cursor is in field object "Customer::nameLast" field on layout on "Main" file and the field is referenced to "Customer" table on "Master" file.
GetSourceFileName ( Get ( ActiveFieldTableName ) )
-> "Master"

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetSourceFileName ( NameTableOccurrence )

Comments

Support this website.

Support this website.