11 Replies Latest reply on Oct 2, 2014 6:57 AM by beverly

    FileMaker Pro 13 - Adding values from ExecuteSQL to fields on layout

    jas.singh

      Hopefully a quick one for all you Pro's out there...

       

      I'm using the following script:

       

      Let (

      $$LabNo = MyLayOut::ShortLabCode ;

       

       

      ExecuteSQL

      (

      "

      SELECT RowID, Forename, Surname, RXKNumber, DOB, Sex, ShortLabCode

      FROM FM_ICE_TP2_PatientOrders

      WHERE ShortLabCode = ?

      " ;

      " * " ;

      "" ;

      $$LabNo

      )

       

      )

       

       

      this returns the following:

       

      1 * Bob * Smith * ZH071688 * 1964-08-01 00:00:00 * M * 5412670

       

      How do I display these values on a new layout

       

      I'm assuming I need to create $variables and then use SetField

       

      I just needed an example of the syntax

       

      Many Thanks (in anticipation!!)