2015年11月27日金曜日

メモ:ExecuteSQLメタ関数

メモ: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 件のコメント:

コメントを投稿