killerwqp.blogg.se

something like thisįieldComment ( Get ( FileName ) GetFieldName ( tableName::fieldName ) ) You could combine these so that you could query the FileMaker_Tables and then the FileMaker_Fields for each table, and build up a list of fields to pass to the FieldComment function, e.g. The FileMaker_Fields virtual table doesn't return the value for the Field Comment unfortunately - you still have to use the FieldComment function to retrieve this. For repeating fields you will get details like this:Ĭontacts,Address,varchar,66,Normal,20,2

It will return additional information about the fields, not just the field name like the above custom function. Is it possible to add the FieldComment functionality into this function?ĮxecuteSQL ( "SELECT * FROM FileMaker_Fields" "" "" ) Hey I never use them personally but does anyone have a solution that lists each repetition of repeating fields too? Returns a sorted list of all Field Names for specified Table Occurrence in the current FileMaker Pro v12 file (Table Occurrence can reference external files). © 2012 Andrew Duncan, Databuzz, Sydney, AustraliaĮxecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName='" & TableOccurrenceName & "' ORDER BY FieldName" "" "" ) Click to copy

VERSION: 1.0v1 - for FileMaker Pro v12 Filed Names are returned in alphabetical order NOTES: Returns a sorted list of all Field Names for specified Table Occurrence in the current FileMaker Pro v12 file (Table Occurrence can reference external files) Function definition: (Copy & paste into FileMaker's Edit Custom Function window) // SYNTAX: ListFieldsFromTable (TableOccurrenceName)