fmEasySync query on script "Prepare Payload for Client"

[Franco]

this query should select from the table only  the records of the group set by the variable $PrivGroup, the query work fine without the red part, please were i am wrong?

 

 

Var   $dyn_sql :

 

--------------------------------

"SELECT " &
$dyn_sql & ", '" & $$record_delimiter & "'" &
" FROM "" & $sync_table & """ &
" WHERE "
&
" ( ES_PrivGroup =  ""  & $Privgroup   & ""  ) "
&
" AND ( COALESCE ( ES_Exclude, 0 ) = 0 ) ) "

&
If ( ( $$sync_method = "Merge" ) and ( $last_pull_utc > 0 );  

"AND ( ES_UTC_Time > " & $last_pull_utc & " ) "
&
"AND ( COALESCE ( ES_Device_ID, 'X' ) <> '" & $client_persistent_id
&
"') "

; "" )

--------------------------------

the red part is my add, i get the error code 106.

Please tell me were i am wrong?

[Lee Smith]

Automatic message

This topic has been moved from "FQL or FileMaker Query Language" to "FM EasySync".