AnsweredAssumed Answered

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

Question asked by jas.singh on Oct 1, 2014
Latest reply on Oct 2, 2014 by beverly

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!!)

Outcomes