AnsweredAssumed Answered

SQL: Querying within the same table

Question asked by tays01s on Sep 7, 2018
Latest reply on Sep 7, 2018 by beverly

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\"=?.

Outcomes