Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral


  • Rank

Profile Information

  • Gender
  • Location
    France - Val de Marne
  • Interests
    Medicine Photo FM

FileMaker Experience

  • Skill Level
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

1,085 profile views
  1. Hello, 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 FROM SERV_POLE WHERE POLE = ? " ; "" ;""; "SARMU" ); "¶" ; "','")] ; "'"&sql&"'") and I got : 'ANESTHESIE','MORTUAIRE','PRELEVEMENT D ORGANE','REANIMATION','SAMU','UCMJ','URGENCES' With ($$liste pasted ) : ExecuterSQL ( "SELECT AVG(AGE) FROM IDENTITES WHERE SERVICE IN ('ANESTHESIE','MORTUAIRE','PRELEVEMENT D ORGANE','REANIMATION','SAMU','UCMJ','URGENCES')" ; "" ; "" ) And ExecuterSQL ( "SELECT AVG(AGE) FROM IDENTITES WHERE SERVICE IN (SELECT SERVICE FROM SERV_POLE WHERE POLE = ?)" ; "" ; ""; "SARMU") I had the same result : 41.907258064516129, but the second way to do is easiest and elegant Sorry, I don’t speak (and write) english fluently but I hope this helps you. Gérard
  2. Hi, Try ORDER BY 2 DESC..... (ref to second column) Good luck G
  3. Hi, Try use "workflow._IDDocLog" (only one dot for all names of fields) and not workflow::_IDDocLog. Yes underscores may be a problem at the begining of names Have a good day G
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.