AnsweredAssumed Answered

Getting an ID from last modifed Date

Question asked by chart97 on Feb 8, 2018
Latest reply on Feb 8, 2018 by chart97

Hi All,

I have a table "Note":

I need to put the locate the last Date_Mod, take the corresponding _kp_note into a variable for use in a scrip.  I'm not a programmer and i'm just learning FM.  I tried to make a simple SQL quarry:

 

ExecuteSQL ( "

SELECT \"_kp_note\"

FROM Note

WHERE (SELECT MAX(\"Date_Mod\")

"

    ; "" ; "" )

 

And read the output into a $variable

 

I am working in FM15 pro, mac.  Is an easier way of doing this without SQL?

Outcomes