Get Table Fields as List

[jgrunschel]

Hello,

I was wondering if there is a Get function that retrieves the names of all of the fields from a specified table and returns them as a value list.

For example lets say you have a table of People with the following fields:

ID

FirstName

LastName

Address1

Address2

...

Then, GetFieldNames ( People ) would return:

ID

FirstName

LastName

Address1

Address2

...

A custom function could probably do this, but I am not very skilled at writing CFs. I did a really quick search of Brian Dunning's site, but did not see an appropriate CF.

[corn]

No custom function necessary.

Use the FieldName() function but instead of a layout name for the second argument, supply the table occurrence name (making certain there is no layout with the same name).

[jgrunschel]

Awesome! Worked like a charm:

FieldNames ( Get ( FileName ) ; Get ( LayoutTableName ) )