FieldsForTable ( table )

get name of fields for a given table

Average rating: 5.0 (2 votes) Log in to vote

Hisc - Show more from this author
noplace
http://nourl

Sample input:

FieldsForTable ( "customer" )

Sample output:

"kp"
"first name"
"last name"

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

/* table parameter may be:
1) empty: CF will use layout table name
2) field reference: CF will use table
3) name of table
*/

Let ( [
	table = Case (
			IsEmpty ( table ) ;
				Get ( LayoutTableName ) ;
			EvaluationError ( GetFieldName ( table ) ) ;
				table ;
				GetValue ( Substitute ( GetFieldName ( table ) ; "::" ; ¶ ) ; 1 )
			)
];
	ExecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName='" & table & "'" ; "" ; ""  )
)

This function gets a table and returns it's fields

Comments

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

FieldsForTable ( table )

Comments

Support this website.

Support this website.