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 ( "
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?