ExecuteSQL template for FileMaker which allows for viewing the query in the data viewer while debugging, and testing for an error.

ExecuteSQL

Let ( [
	$sqlQuery =
		"SELECT "
			& SQLTableAndField ( field )
		& "¶FROM "
			& SQLTable ( field )
		& "¶LEFT JOIN "
			& SQLTable ( field )
		& "¶ON "
			& SQLTableAndField ( field )
			& " = "
			& SQLTableAndField ( field )
		& "¶WHERE "
			& SQLTableAndField ( field )
			& " = ? "
		& "¶AND "
			& SQLTableAndField ( field )
			& " = ? "
		& "¶ORDER BY "
			& SQLTableAndField ( field )
			& ", " & SQLTableAndField ( field ) & " DESC"
		& "¶GROUP BY "
			& SQLTableAndField ( field )
	;
	$sqlParameter1 = "value" ;
	~start = Get ( CurrentTimeUTCMilliseconds ) ;
	$sqlResult = ExecuteSQL (
		$sqlQuery ;
		SQLFieldSeparator ;
		SQLRowSeparator ;
		$sqlParameter1
	) ;
	$sqlRuntime = Get ( CurrentTimeUTCMilliseconds ) - ~start ;
	$error = If ( $sqlResult = "?" ;
		ErrorApp ( 17 ; "" )
			& # ( "sqlQuery" ; $sqlQuery )
			& # ( "sqlParameter1" ; $sqlParameter1 )
			& # ( "sqlRuntime" ; $sqlRuntime )
		;
		$error
	)
] ;
	$sqlResult
)