メモ:ExecuteSQLメタ関数
参照:
http://notonlyfilemaker.com/wp-content/uploads/2014/01/The-Missing-FM12-ExecuteSQL-Reference-ja.pdf
引用:
FILEMAKER_TABLES
1. TableName
2. TableID
3. BaseTableName
4. BaseFileName
5. ModCount
FILEMAKER_FIELDS
1. TableName
2. FieldName
3. FieldType (SQLのデータ型。FileMakerのデータ型ではない)
4. FieldID
5. FieldClass (Normal, Summary, Calculated)
6. FieldReps
7. ModCount
Let (
[ $query = " SELECT *
FROM FileMaker_Tables "
; $header = "TableName, TableID, BaseTableName, BaseFileName, ModCount¶"
; $result = $header & ExecuteSQL ( $query
; ", " ; "" )
]; $result
) //
Let (
[ $query = " SELECT *
FROM FILEMAKER_FIELDS "
; $result = ExecuteSQL ( $query
; ", " ; "" )
]; $result
) //
0 件のコメント:
コメントを投稿