The first pdf explains that in the « IN » order, with dynamic parameters, each item must be enumerated separately.
In our case, as Kevin Franck state in 2012 in The Missing FM 12 ExecuteSQL Reference
« If the list is TEXT, then the values, must be enclosed with single quotes (‘abc’,’def’,’ghi’,’jkl’). These values will be automatically be quoted as needed, if you nest another SELECT inside. »
Before our exchanges I have tried in one of my database:
Definir variable $$liste ; valeur : Definir (
[sql = Substituer ( ExecuterSQL ( "SELECT SERVICE