4 Replies Latest reply on Sep 12, 2016 6:10 PM by beverly

    Add text to beginning of each sql calc

    MartinBishop

      Trying to add text to sql as shown below... I've tried substitute (list ( ) ) but with no luck, close but no cigar

       

      ExecuteSQL ( "

      SELECT Person, Place ¶

      FROM Spaces INNER JOIN Person  ¶

      ON Spaces.\"_fkPersonID\" = Person.\"__PersonID\" ¶

      WHERE Spaces.\"_fkPlacesID\" = ?

      ORDER BY \"__PersonID\" DESC ";

      ": "; "¶" ;

      __PlacesID ) ;

       

      Outputs

      John: Home

      Bob: Office

       

      Trying to get

      - John: Home

      - Bob: Office

      - Blah: Blah