ExecuteSQL RIGHT,STRVAL,DATEVAL 使用例｜FileMaker

ExecuteSQL RIGHT,STRVAL,DATEVAL 使用例｜FileMaker

ExecuteSQL (
"
SELECT
RIGHT('00'||STRVAL(M.\"order\"),3)  as \"order\" 
FROM  \"売上明細\" M 
WHERE
M.\"_kf_売上\" = '2C866CE8-8793-6E48-964E-E26BC7A97471'
AND M.Label IS NULL 
"
; ""; "")


ExecuteSQL (
"
SELECT
DATEVAL(U.\"売上日\") as \"伝票日付\"
FROM  \"売上\" U
WHERE
.....
AND
U.Label IS NULL
"
; ""; "")