I'd like to get a value for field 'Y' from field 'X' within the same table. I'd tried:
ExecuteSQL("SELECT (Std_EN) FROM Nut_Calcs WHERE \"_IOuuid\"=?" AND \"__uuID\"=?";"";"";IO_n::__uuid; Nut_Calcs::__uuID)
where "__uuID" is the record within which I want a value found from: Nut_Calcs::__uuID. However, FM reports that a 'number, text constant, field name or (' is expected just before: \"__uuID\"=?.