1 of 1 people found this helpful
In your Test script, the query references a non-existent field "nom". In "Nouveau script", the query is missing a closing parenthesis at the end of the sub-query.
Thanks for the answer. I finally found the issue. The id was declared as Text instead of Number. It would be nice that Filemaker returns the sql error code or comment, instead of a question mark. I tried with Get(LastError) or Get(LastExternalErrorDetail), but nothing is returned.