FileMaker ExecuteSQL｜フィールド名取得

ファイルメーカー フィールド名取得

Let (
[ $query = " SELECT FieldName
FROM FILEMAKER_FIELDS
WHERE TableName = '{TableOccurrence}'
AND
FieldClass = 'Normal'
AND
FieldType NOT LIKE 'global%'
AND
FieldName NOT IN('{Field1}','{Field2}')
"
];
ExecuteSQL ( $query　; ", " ; "" )
)