FileMaker ExecuteSQL の戻り値を JSON で取得する｜Getting the return value of ExecuteSQL as JSON

 ExecuteSQL の戻り値を JSON で取得する

• 変数を設定 [ $query; 値:
  Let ( [
  $query ="select
  '(((.Code.))):(((.'||`Code`||'.)))'
  ,'(((.Name.))):(((.'||`Name`||'.)))'
  FROM `Position`
  WHERE `Name` LIKE '%{名称}%'
  FETCH FIRST 10000 ROWS ONLY "
  ];
  　Substitute ( $query
  　; ["`"; "\""]
  　; ["{名称}"; ValueListsThing::g_Search ]
  　)
  ) ]
• 変数を設定 [ $Result; 値:ExecuteSQL ( $query　; "," ; "},{" ) ]
• 変数を設定 [ $Result; 値:"[{" & Substitute ( $Result ; [¶ ; "\\n"] ; ["\"" ; "\\\""] ; ["(((." ; "\""] ; [".)))" ; "\""] ) & "}]" ]

Getting the return value of ExecuteSQL as JSON

• Set Variable [ $query; Value:
  Let ( [
  $query ="select
  '(((.Code.))):(((.'||`Code`||'.)))'
  ,'(((.Name.))):(((.'||`Name`||'.)))'
  FROM `Position`
  WHERE `Name` LIKE '%{名称}%'
  FETCH FIRST 10000 ROWS ONLY "
  ];
  　Substitute ( $query
  　; ["`"; "\""]
  　; ["{名称}"; ValueListsThing::g_Search ]
  　)
  ) ]
• Set Variable [ $Result; Value:ExecuteSQL ( $query　; "," ; "},{" ) ]
• Set Variable [ $Result; Value:"[{" & Substitute ( $Result ; [¶ ; "\\n"] ; ["\"" ; "\\\""] ; ["(((." ; "\""] ; [".)))" ; "\""] ) & "}]" ]