Jump to content

LAIRY

Newbies
  • Content count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About LAIRY

  • Rank
    newbie

Profile Information

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

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

FileMaker Partner

  • Certification
    Not Certified
  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, This may help you Good luck Gerard SQL 5.pdf
  3. Hi, Try ORDER BY 2 DESC..... (ref to second column) Good luck G
  4. 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
×

Important Information

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